Form field's color

B

Boon

Hello,

I have a subform within a form. In my subform it displays the data from one
table. It has 5 columns. I want to have column3 to column5 colored in Red.
How can I do this? (Says that I want to tell the user to input the data in
the Red area).

I have tried to use conditional formatting but somehow it doesn't work.

Thanks a lot
 
A

AJOLSON

Change the subform view to Continuous Form then set the field proerty to the
color you want 255 for vbred.
 
R

Ron2006

What was the test you were using.

If you want it to ALWAYS be red then the following will work. I have
used it many times.

Select the field.
right click and select conditional formatting.
Change the item on the left to say Expression
Type True in the expression field
Select the formating that you want to show.


Works every time.


Ron
 
B

Boon

Hi Ron,

I have tried it and found out that there is a delay. It looks like it needs
time to refresh when I enter data into the colored cell. Probably about half
a second.

Boon
 
R

Ron2006

Just for the heck of it, (to see if it speeds things up) you could try
and put a me.repaint in the afterupdate event of the field.

Ron
 
Top