Format question

[Dale]

Hi, I am looking through some old Access queries and I ran across stuff
like:

Format$([labelTempPrint].[unitofmeasure],"&") being compared for
equality to ""

and

Format([LabelTempPrint]![UnitOfMeasure],">") being used with the Left
function

I looked all over and cannot find what the "&" and ">" would mean. Can
anyone shed any light on those two? Thanks.

 

[Guest]

dale-
The "&" and the ">" are formatting symbols. The & means that a text
character is not required in the field (it can be a number instead). The >
forces all characters in the field to uppercase. Hope this helps....

 

[Marshall Barton]

Hi, I am looking through some old Access queries and I ran across stuff
like:

Format$([labelTempPrint].[unitofmeasure],"&") being compared for
equality to ""

and

Format([LabelTempPrint]![UnitOfMeasure],">") being used with the Left
function

I looked all over and cannot find what the "&" and ">" would mean. Can
anyone shed any light on those two? Thanks.

Help topic: Format Property - Text and Memo Data Types

& picks up an optional character

 

[Dale]

Thanks Pete and Marshall.