Continuous Forms

L

Luis

Hello.
I have a continuous form that i'd like to format the text boxes differently
for the records that match a certain condition. This condition is in one of
the form fields.
Is possible to, for instance, change the background color of the text boxes
for the records that match this criteria and keep the original format of the
other one's?

Thanks
Luis
 
F

fredg

Hello.
I have a continuous form that i'd like to format the text boxes differently
for the records that match a certain condition. This condition is in one of
the form fields.
Is possible to, for instance, change the background color of the text boxes
for the records that match this criteria and keep the original format of the
other one's?

Thanks
Luis
Click to expand...

if you have Access 2000 or later you can use the control's conditional
formatting property.
In Design View, select the control. Then ...
Format + Conditional Formatting
 
L

Luis

The problem is that i want to format the entire row only for the records that
has a certain value on a certain field. The remaining records doesn't alter
the format.
 
J

John Vinson

Hello.
I have a continuous form that i'd like to format the text boxes differently
for the records that match a certain condition. This condition is in one of
the form fields.
Is possible to, for instance, change the background color of the text boxes
for the records that match this criteria and keep the original format of the
other one's?
Click to expand...

This is possible with versions of Access from 2000 on (much more
difficult in older versions). Select the textboxes, and choose
Format... Conditional Format from the menu.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
J

John Vinson

The problem is that i want to format the entire row only for the records that
has a certain value on a certain field. The remaining records doesn't alter
the format.
Click to expand...

Use the Expression option on the conditional-format window. For
instance to turn the entire row red if BalanceDue is positive, use an
Expression

[BalanceDue] > 0

on the Expression textbox, and apply the format to every control that
you want to change color.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top