Conditional Formatting to Change Background Colour

[euphonium01]

I have a control on a Form called 'Invoice' that can contain Text or a Number, the Form is displayed in Datasheet View. When viewing the datasheet and need to see immediately if the 'Invoice' field contains text, so I am trying to make it stand out by setting the background to a different colour if does contain text. I tried using Conditional Formatting to achieve this but, I don't know the correct 'Expression Is' to use. Can anyone help me with this, or advise me of a better way to do it? Thanks in anticipation

[JoeM]

If you are just looking for the existence of an entry, one way is to use the LEN function, i.e.

LEN([FieldName])>0

[euphonium01]

If you are just looking for the existence of an entry, one way is to use the LEN function, i.e.

LEN([FieldName])>0

No, the entries are no problem, what I want is for the background colour to change if the entry is text, and remain 'normal' if the entry is a number. The vast majority of data entries in the Invoice control are numbers, however, sometimes there is text in there (such as "awaiting invoice #", or "credited" etc). When viewing in Datasheet view, I want the control to stand out if the data is text by changing the background colour, I thought the best way might be to use Conditional Formatting? Sorry if this wasn't clear in my first posting.

[JoeM]

Check out the IsNumeric function (http://www.techonthenet.com/access/f.../isnumeric.php).
You should be able to use this in your Conditional Formatting to do what you want.