long integers

D

dennist685

In access 2007, I don't see how to choose long integer for a field, a foreign
key for example. Just number.

Can somebody help?

dennist
 
T

tina

open the table in Design view. click on the field that has a Number data
type. look at the bottom half of the window where the Field Properties are
listed. the first property on the General tab is Field Size.

hth
 
T

tina

oops, sorry, i didn't notice that you're working in A2007. its' Design view
may very well be different than in previous versions of Access.
 
K

Ken Snell \(MVP\)

tina said:
oops, sorry, i didn't notice that you're working in A2007. its' Design
view
may very well be different than in previous versions of Access.


Not to my knowledge -- it should be same as in previous versions.
 
T

tina

i didn't say "diagram", hon, i said Design view. i don't have Acess 2007,
but i'd guess it's similar enough to prior versions that, if you open the
table in Datasheet view, you'll find a toolbar button or menu option to take
you to Design view.

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

Top