field sizes

P

puthputh

Hello,

I need to set the field size in a field which's data type is:

-AUTONUMBER
-NUMBER

I've been told it is possible, but I don't know how.

Please help. Thankyou
 
R

Rick B

Are you trying to set the size in th etable? In a form? In a query? Why
are you trying to do so? What is the size now, and what do you want it to
be?

An autonumber is simply a control used to make a unique key for a record.
The format and size of an autonumber should not be important to you. If you
are trying to use the number and want it to be logical, I'd suggest you make
it simply a number and set the value when you add a new record to the table.
Using auto-number is probably not what you are looking for.

Post more details as to what you are trying to do and why.

Rick B
 

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

Top