Can we change appearance of 1 record in a continuous form?

  • Thread starter Thread starter Mota
  • Start date Start date
M

Mota

Hi;
I want to chage the BackColor of one control named txtInStock,if meets a
special condition(For Example,having InStock<100),to VbRed.Considering that
records are shown in a continuous form,and changing a property affects all
records or none,how can i do this?
Thank you in advance.
 
Thank you Jim for ur help,It works fine.But:
What i want is to affect all the record.For example if Expiry Date of 1
Recors is between now and 6 month later(Now()+180),Change back color of all
controls containing this record.This mean changing format of some controls
based on another control in that grid.The thing we simply do at run time
code of a non continuous form.But in a continuous form,do u think its
possible?
Thanx again for ur attention.
 
Thank you Chet;
When i use Expression Is,and set a condition for txtInStock,Just the numeric
text boxes will be affected and for example,txtSupplierName that has a
string value,still remains in its original back color.Do u have a solution
for this?
Thank you.
 
Back
Top