Lookup Field Size

[Sam]

In my Master table I have a lookup field from the Account table. In the Acct
table the field size is 150 and works fine. In the Master table this field
says it is too large and I must paste less data. How do I fix this???
Thanks!

 

[Duane Hookom]

You avoid lookup fields defined in tables.
http://www.mvps.org/access/lookupfields.htm

 

[Duane Hookom]

I should have provided a little more direction. You can use combo boxes on
forms to ease your data entry using a drop down of values from a related
table.

I can't imagine a "primary key" field of up to 150 characters. A combo box
should allow 255 characters.

 

[Sam]

Thank you for your prompt reply. Neither field is the Primary Key. How do I
keep from having to enter repeated data without a lookup?? In the Account
table I have 3 fields with bank account data. I don't want to have to enter
this with each entry into the Master database.

 

[Duane Hookom]

As I suggested, use a combo box on a form. You don't have to define a lookup
field in a table design to be able to use a combo box on a form.

 

[Sam]

I created a Combo box in my form. However, I still get the message that their
is too much data for the space. I can't find a place to set the size except
in column width and this doesn't seem to make any difference. I must be
missing something basic, but I don't know what.
Thank you for your replies.

 

[Duane Hookom]

What are the field sizes in both tables? Can you provide this information
for your combo box:

Name:
Control Source:
Row Source:
Bound Column:

 

[Sam]

Isn't the only option for Bound a Yes or No? I cannot find anyplace to set
the field size other than column width on the form for the combo box.

 

[Duane Hookom]

Field sizes are found by opening your table in design view.
I'm not sure what you mean by "Bound". A control can either be bound or not.
If it is not bound, there will be nothing in its control source. If a
control is bound, you should see a field name or expression in its control
source property.