@ symbol in access 2007 text field format property

G

Guest

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble Importing text file into Access 2007 1
The symbol * in a database 7
Why are not all symbols in Word accepted in an Access text field? 2
Access 2007 runtime database not open in Windows Server 2003 1
Symbol "font" doesn't act like other fonts 1
Cannot cut and paste trademark (TM) symbol into Access text or memo field 1
Symbol "font" - not Unicode compliant, how to Search/Replace? 2
How do you find and replace unwanted symbols in text cells? 2

Top