G
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
key for example. Just number.
Can somebody help?
dennist
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell \(MVP\)
It's in the Field Size property.
G
Guest
thanks, but I can't find the field size property anywhere
dennist
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
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.
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
whew...skated on that one! <g>
Ken Snell (MVP) said:Not to my knowledge -- it should be same as in previous versions.
G
Guest
I find no diagram view when reating a table. Where is it?
dennist
dennist
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
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