Textbox fields on continuous forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can you have different coloured text in a text box of a continuous form.
For example I would like the text to be red if the value is 25% or greater
all other value should have black text. The data type is percent with 1
decimal point.
 
Assuming you're working with Access 2000 or later, select the field, goto
Format > Conditional Format and set your condition and text format preference.
 
How can you have different coloured text in a text box of a continuous form.
For example I would like the text to be red if the value is 25% or greater
all other value should have black text. The data type is percent with 1
decimal point.
Click to expand...

For Access 2000 or greater, (I'm not sure about A97) With the form in
design mode, click the text box you want to format, and from the pull
down menues click "Format", "Conditional Formatting..."

That will open up a dialog box similar to the one in Excel.

HTH,
Chris
 
Using Format | Conditional Formatting, you do this using the following
settings
Field Value Is | greater than or equal to | 25%
and
select the color to change it to
Bear in mind, this will only work correctly if the textbox is bound to a
field. If unbound, the textbox will be affected for all records
simultaneously
 
Back
Top