Microsoft Office 2000 - Access

  DEZIBOY 13:53 18 Oct 04
Locked

When using conditional formating on a control field, how do you prevent numbers 1 to 9 from using the same field format as the numbers 10 to 90?

  recap 15:23 18 Oct 04

Open the form in Design view or Form view, or the report in Design view.

Make sure that the control is selected, and then on the Format menu, click Conditional Formatting.

Do one of the following:
To change an existing condition, select the font style, color, or other formatting that you want to apply.

To add a new condition, click Add.

To remove one or more conditions, click Delete, and then select the check box for the condition or conditions you want to delete.
Click OK.

  DEZIBOY 08:57 19 Oct 04

The response from 'recap' is correct but how do you prevent numbers 1 to 9 from using the same field format as the numbers 10 to 90 when you have used all the conditions that you are allowed to add (3 in Access) and the numbers 1 to 9 are outside the conditions you have set up?

  recap 09:03 19 Oct 04

What Type of field are you using, Text or Number?

  DEZIBOY 13:02 19 Oct 04

I am using a number field

  recap 16:20 21 Oct 04

Changing the field properties from Long Integer to Single may work?

  DEZIBOY 16:30 21 Oct 04

Thanks to 'recap' for your efforts in trying to find a solution. However, I have successfuly implemented the conditional formating on another copy of Microsoft Access, which leads me to the assumtion that my copy has somehow been corrupted.
therefore the only option I have is to remove and reinstall Microsoft Office

This thread is now locked and can not be replied to.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

This 2D animation about monsters is illustrated in a Van Gogh painterly style

How to get WWDC 2017 tickets