long integers

[Guest]

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

 

[Ken Snell \(MVP\)]

It's in the Field Size property.

 

[Guest]

thanks, but I can't find the field size property anywhere

dennist

 

[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

 

[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.

 

[Ken Snell \(MVP\)]

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.

 

[tina]

whew...skated on that one! <g>

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

 

[Guest]

I find no diagram view when reating a table. Where is it?

dennist

 

[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