Changing Field Background Colour

Mar 31, 2006

I'm opening a form in snapshot view and would like the background colour of all the fields in the form to be a dark colour to show that it is in snapshot. the user then clicks Amend and the background colour would change to something lighter to show they can amend the record. Is there any way of on the OnClick event of the Amend button change all the fields (and there's lots) at once without having to name them all individually, ie:

Me.text1.background = whatever
me.text2.background = whatever

Thanks

View Replies


ADVERTISEMENT

Forms :: Changing Background Colour Automatically

Jun 16, 2014

Here, what I am trying to learn, that background of the form change its colour automatically after sometime let say 1 min or after 2 min

I find the link on the web where more than 500 colour code are available, but not sure, how I can use [URL] ....

I can put this command on form_load()
Me.Detail.BackColor = ?????????
but question is how i can bring other colour into loop

Plus, if the user want to do any work on the same form, will this loop also allow the user to do any work, I mean form should not be stuck up in the loop of changing a colour...

View 1 Replies View Related

Lookup Field / Combo Box - Changing Colour Of A Cell?

Mar 7, 2012

I have a Lookup field/combo box and want to have the cell colour change if a certain word is chosen. if not then the cells stay the same.

i.e., if "cancelled" the cell turns red, if any of the other two options are chosen, then leave as is.

View 3 Replies View Related

Tab Background Colour

Apr 26, 2006

This should be an easy one for somebody. I'm a newbie to access and I'm experimenting with a tabbed form. My problem is if I create a new form with (say) two tabs, the area to the right of the tabs(where more tabs would be inserted) is white and I don't know how to change it to blend in with the rest of the page. Hope I'm making myself clear.:(

View 3 Replies View Related

Background Colour

Oct 18, 2006

Hi
We have created some forms using (in some cases) the form wizard.
As you may know you have to select a "Background Style" when using the wizard.
Now we want to change the background from one of these styles to a colour - but when we select it in Properties and try to apply it, it seems to flicker but does not seem to have any effect.
Can anybody help us out please ?
many thanks
ajm

View 1 Replies View Related

Change Background Colour !

Jan 24, 2007

Hi,

I'm currently using MS Access 2002.

I use forms to display client info and i would like to know if the following is possible, and if so, how ?

When a clients installation date is older than 6months old (date is in a text box) i would like the form's background to change colour for that paticular client.

eg/ if the clients installation date was 7 months ago, the form's background would change red - but only to that client.

Kinds Regards
Chris

View 4 Replies View Related

Tab Control Background Colour

Apr 17, 2007

Hi all,

I have been searching for a setting that enables me to change the background colour of a tab control on a form. It may be something obvious that I have missed.

Changing the type to 'transparent' and setting the form background colour does not seem to work.

Any ideas?

Cheers,

Rob

View 5 Replies View Related

Unbound Subform Background Colour

Jun 27, 2006

Hi guys,

Something that's been bothering me. I have a unbound subform which acts as a placeholder for other subforms rotating on it (by changing the SourceObject), that way all the relevant subforms appear in the right place when required. It works great except, it's this great big white box and there's no option to change the background colour anywhere. I would like it to be either transparent or have an option to change it to the same colour as my main form it sits on.

Any way to do this?

View 2 Replies View Related

If NULL Then Change Background Colour

Aug 26, 2004

Im trying to change the background colour of some fields if the value is null or missing, but I'm not quite sure how to handle the coding. The fields in question are title, given name and surname, and if they are empty I want to change the background colour to highlight to users that they need to collect this information.
Any help that you can provide would be great!

View 4 Replies View Related

General :: Remove Background Colour When Outputting To PDF

Mar 20, 2014

I have a form with subform that uses colour as background colour for all fields on the form, and also a very light background for the whole form. This outputs very well to PDF, retaining all of the layout etc.

However, consisting of over 100 pages I do not want any colour at all in the printed report, no do I want the colour converted to black or grey. Inkjet cartridges are just too expensive!

Is there an easy way to remove all colour before printing or do I have to design another report?

View 2 Replies View Related

Forms :: Change Textbox Background Colour Pending Value Of Two Textboxes On Form?

Jul 9, 2013

I have a form with two textboxes that get their values from two different queries that counts records from table. If textbox1.value equals texbox2.value the textbox2.value back ground colour is green. If they are not equal textbox2.value goes red. Itried with using conditional formatting, but it doesn't work all the time as the form is not updating when it is opened.

View 4 Replies View Related

Changing The Colour Of A Textbox

Dec 5, 2006

Is it possible to change the colour of a textbox, after clicking on a command button?

View 1 Replies View Related

Changing The Colour Of An Item In A List Box

Sep 13, 2006

HI all, the objective is to grey out an item within a listbox, where the id number is the same in another sub form. The sub form is called contacts and the list is called list15. the unique id that is linking the two is SWD.

HELP...:confused:

View 1 Replies View Related

Colour Changing Fields In List Box

Mar 16, 2008

Hi there guys,

I need a little help on a little situation. Basically, my client for my school project wants to be able to see graphically if orders sent to their bookstore have been processed or not. So i suggested a change of cololour of the fields.

Now I have created a Form containing the orders as they are stored in a list box, (both already processed and unprocessed orders), now I want to be able to allow each item in the list box to be either Red (if unprocessed) or green (if processed) so the user can see which ones they need to deal with. Im guessing this would take some VB, but if anyone could help me, I would really appreciate it :).

PS, if you do provide VB could you please explain a little of whats going on as i have to annotate all the code I use and im not too profficient in VB

Thanks a lot

Dan

View 1 Replies View Related

Changing Colour In Datasheet View

Jun 27, 2006

Well, I got asked to do this with a datasheet view today, and I found after searching the forum that I'm not sure how to do it, and no one else seems to have done this either.

Basically I need to flag a row in a datasheet subform dependant on if a date field is more than 1 month ago and if the status field is set to pending. I looked at conditional formatting, but that only seems to let me set a condition on a single field at a time.

Any help would be appreciated :)

View 4 Replies View Related

Changing Text Colour Of Labels On Activate

Nov 23, 2005

Hi, im working on my school project for A2.

When the user clicks on say; the customer ID dropdown menu, i want the label text on the right of it to get darker (make it more visible). How can i do this?

(i have attached a picture of my form)

thanks, Robin

View 2 Replies View Related

Changing Command Button Text Colour.

Jun 30, 2006

Hi all,

I'd like to change the colour of the text in a command button when the user click the button, but for the text to return to it's original colour when the botton pops back up.

I'm assuming you use the following commands:


Private Sub cmdClose_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
*******CODE********
End Sub

Private Sub cmdClose_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
*******CODE********
End Sub


But I'm not sure as to how I would enter the correct code.

Any help would be appreciated,

Best Regards,

Aaron

View 2 Replies View Related

Changing Background Color Of Tab Form

Apr 5, 2005

Hi,

I have design a form using the tab control. I need to add in color to make it more professional. Is there a way I can do it. I realised the filled /Back color icon is faded in color in design view.

Appreciate any help in this. Thanks.

View 2 Replies View Related

General :: Changing Font Colour Of One Record In Access Database

Jan 12, 2015

I would like to get a third party to edit a database and record those edits by changing the colour of the font. I know this can be done in layout mode, but it changes the font in all records, I only wish to change the font colour in one record, how I can do this, without changing all the records in the database.

View 3 Replies View Related

Changing Background Color Of A Record Based On Yes / No Value

Jun 26, 2013

I am rebuilding a file that deals with a lot of active and inactive accounts. I would like to change the inactive record to a yellow or red when a check box is marked. It has been about 15 years since I have written any macros or VB functions.

View 5 Replies View Related

!!!changing Font Colour - Simple Question, Quick Response Required If Possible!!!

Feb 14, 2006

i have a text box which displays the current stock level of an item, when the current stock level reaches 1 i need the font to change colour from black to red.
for example, if the stock is 2 - font is black
if one item is sold the stock will become 1 - font changes to red

how do i go about this? any help is VERY VERY welcomed and muchly appreciated. thanx alot.

View 2 Replies View Related

General :: Changing Column Colour In List Box - Alignment For Cells Data

Jan 7, 2014

How can change column color in list box and also how to make alignment left or right for cells data.

View 1 Replies View Related

Reports :: Changing Background Color And Text Format Simultaneously

Sep 8, 2013

How do I change the background colors and text formatting in all of the reports in one database at the same time? If this is not possible, is there an easier way to change the report formatting without going through every report?

View 2 Replies View Related

Change Colour Dependant On Field Value

Jun 28, 2006

Hello,

First please accept my apologies if this has been done before. In the attached database I am going to have a form which is continous what I am looking to do is change the colour of the box which is in the background to the associated colour from the quote table for example

if they choose water then it will look at the TBLQuoteType and change the box colour to the colour which has been assigned to that value.

Hope this explains it ok I will continue to try and figure it out but I thought I could also use your expert knowledge.

14030

Thanks again

View 5 Replies View Related

Automated Field Colour Change

Apr 17, 2005

Is it possible to get Access to automatically change the colour in a form field via code etc. My problem is that i would like to easily pick/see any out of date quotations for my customers, so when the quotation date is 30 days old the text changes to red. Any advice would be gratefully received.

View 1 Replies View Related

Change The Colour Of A TextBox / Field Depending On It's Value?

Jun 7, 2006

Hello fellow programmers, I have a tricky one for you. We have decided to split our local City up into different zones. Giving each zone a number and assigning it a colour. I have a form with all the customers who want jobs done in different parts of the city. This form has a text box on it called: Zone - (which has a 3 digit number it it). I want the colour of the text box to change depending on the Zone number, in the continuous Form view. So all the customers living in Zone=111, will have a Red background colour (color), all living in Zone=222 will have a Green background colour. I know conditional formatting through the properties of the Form can be used, but it only allows me to select 3 different situations. I have many more than 3 colours that I want to assign. I am working on a VB module to define what colour numbers from the MS Access Colour Map will be assigned to each Zone number. How can I now apply this module to the form, so when it opens, all the customers who live in Zone=111 will have a Red coloured background, those living in Zone=222 will have a green colour background, etc?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved