@ symbol in access 2007 text field format property

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mark - 12 Sep 2007 22:32 GMT

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

Reply to this Message

George Nicholson - 12 Sep 2007 23:12 GMT

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,

> HI,
> When I import a worksheet from Excel 2007 into Access 2007, the text
[quoted text clipped - 5 lines]
> Thanks for any help.
> Mark

Reply to this Message