Lookup Field Size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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.
 
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.
 
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.
 
What are the field sizes in both tables? Can you provide this information
for your combo box:

Name:
Control Source:
Row Source:
Bound Column:
 
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.
 
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.
 
Back
Top