Conditional Formatting with "IsNumeric"

Question

Hello All,

I'm currently in the middle of having a rather fierce battle with Access 2010's conditional formatting. Does anyone happen to know if there's a way to incorporate the "IsNumeric" filter in conditional reporting?

As some background: I have a temp table full of results that are either numeric or text (the difference being the presence or absence of the "<"). I would like my conditional formatting to search the field in question and bold everything that is numeric (i.e. does not have the "<" with it). Is that possible? Am I missing something simple? 

Thanks in advance!

Answer 1

Create a form (or report) based on the table.

Open it in design view.

Select the text box bound to the field.

Activate the Format tab of the ribbon.

Click Conditional Formatting > New Rule...

Select 'Expression Is' from the first dropdown.

Enter the expression   IsNumeric([FieldName])   in the box next to it, where FieldName is the name of the text field.

Click to highlight the B (bold) button.

Click OK.

Answer 2

That's wonderful! Makes me feel mildly ridiculous but it's absolutely great. Thanks so much!!