Format question

  • Thread starter Thread starter Dale
  • Start date Start date
D

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.
 
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....
 
Dale said:
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.
Click to expand...


Help topic: Format Property - Text and Memo Data Types

& picks up an optional character
 
Back
Top