Form field's color

  • Thread starter Thread starter Boon
  • Start date Start date
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
 
Change the subform view to Continuous Form then set the field proerty to the
color you want 255 for vbred.
 
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
 
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
 
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
 
Back
Top