format "@"

B

buggirl

Just a quick question -

I notice that in the Field Properties box of my spreadsheets in Design View,
the Format often has a default "@" in there.

Why?

What does it mean?

thanks!
 
F

fredg

Just a quick question -

I notice that in the Field Properties box of my spreadsheets in Design View,
the Format often has a default "@" in there.

Why?

What does it mean?

thanks!
Click to expand...

Spreadsheets? Fields? Design View?
What program are you using?
You may have posted this message to the wrong newsgroup.

The access in this groups name refers to Microsoft Access, a database
program.
If Access is the program you are using, I would suggest you place your
cursor on the Field's Format property line and press F1 for Help.
Click on the links for information on the formatting of various
datatypes.

If that doesn't answer your question then post back with more
information.

If you do mean spreadsheet then...
Please repost to the correct newsgroup for the Excel program you are
using. I would suggest you include your Windows and Office version
number in the message.
 
B

buggirl

I'm sorry, I meant to say 'table' not spreadsheet. It's been a long day at
the computer...

I'm using the 2007 version of Access. The Field Properties box is in the
bottom half of the window when the table is opened in design view.

I think the "@" alters the way that data is stored when using an input mask.

Thanks for your response!
 
G

gllincoln

Hi buggirl,

The @ symbol limits the input to alpha characters (A-Z, a-z)

Cordially,
Gordon
 
B

buggirl

Ah, thank you. That makes perfect sense. It removed the dashes from my input
mask and only stored the alpha characters.

Cheers,

buggirl
 
Top