Re: Lookup Field Size

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.

--
Duane Hookom
MS Access MVP
--

"Sam" <Sam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E0D18D53-9FAD-479C-9E2F-F72DCBEF5306@xxxxxxxxxxxxxxxx
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!


.

Relevant Pages

  • FRENCH CHARACTERS ARE MISPRINTED IN AN ODBC QUERY TO A DATABASE
    ... I am in Canada and I have a database in D3. ... package which allows me to input/print French characters to my database. ... characters is if I change my data entry language. ...
    (microsoft.public.office.misc)
  • How is real and imaginary time data entered for fourier analysis?
    ... The input data is in equation form. ... data entry seems to be characters as opposed to numbers. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Help with field lengths
    ... I can't recall where I found it. ... So if your data is 25 characters, memory used is 25 characters, not ... if you have a requirement to limit the user's data entry to ... I do not reply to personal e-mail ...
    (microsoft.public.access.tablesdbdesign)
  • Re: is there a maximum number of text fields?
    ... I have come to the conclusion that my database is screwed. ... characters in a record is 2000. ... However, my question remains, Can a DAP ... used for data entry, populate multiple related tables? ...
    (microsoft.public.access.gettingstarted)
  • Re: Data Validation
    ... You can cut down on two formulas by setting the combo boxes' MatchRequired property to True. ... Author of Configuring Microsoft Outlook 2003 ... would fill out and email to someone else for data entry. ... must equal 7 characters. ...
    (microsoft.public.outlook.program_forms)