Test for Lowercase in Query 1

[Moss100]

Hello this is a similar question to my previous one regarding problems with null / empty cells

In the query I would like to show whether a field ([AccountName]) contains lowercase characters.

The code I have works when the field has an empty string, but not when null.

My code is as follows:

CheckAccountName: StrComp(UCase([AccountName]),[AccountName],0)

Could someone suggest a more robust approach?

Many thanks Mark

 

[Andrzejek]

The code I have works when the field has an empty string, but not when null." - I would try this:

CheckAccountName: StrComp(UCase(AccountName [blue]& ""[/blue]), AccountName [blue]& ""[/blue], 0)

---- Andy

There is a great need for a sarcasm font.

 

[Moss100]

Thank you Mark