@ symbol in access 2007 text field format property

M

mark

HI,
When I import a worksheet from Excel 2007 into Access 2007, the text fields
all have an @ symbol in the format property. Can anyone tell me what the @
symbol means? I haven't been able to find any format references to that
particular symbol.
Thanks for any help.
Mark
 
G

George Nicholson

Not sure this is the full answer, but in VBA Help, under User-Defined String
Formats (Format Function), @ is listed as a Character placeholder: "Display
character or space" as opposed to & which is "Display character or nothing".

Something in the back of my mind is telling me this could also be related to
specifically formating a cell in Excel as "Text", but I can't put my fingers
on confirmation of that at the moment.

HTH,
 
Top