expression to identify leading alpha character (1 Viewer)

[Rats]

Hi

I have a field that contains receipt numbers, most of which are numeric but a few commence with an alpha character such as "A12345". When the field starts with an alpha character I need to use conditional formatting to highlight the field.

Can anyone help me with an expression I can use in the conditional formatting to identify the situation above?

Appreciate your assistance..

 

[Alansidman]

Take a look at this post. I think it may have your answer.

http://www.vbforums.com/showthread.php?t=544777

Alan

 

[missinglinq]

In Design View for your form, select your receipt number textbox, goto

Format - Conditional Format

and select

Expression Is:

then in the expression box enter

Not IsNumeric(Left([ReceiptNumber],1))

replacing ReceiptNumber with the actual name of your textbox.

Now select the formatting you want and then click on OK.

 

[Rats]

Thanks for everyones rapid response. I followed the link provided by Alansidman and came up with the Conditional Format expression of

[myfield] Like "[a-z]#*"

.
It seems to work a treat. But I wonder if it is as good as the code suggested by missinglinq.

Thanks again.

 

[missinglinq]

Six of one, half a dozen of the other!

My signature line really says it all!

 

[Rats]

Ain't that the truth. Thanks for the response.