Combo Box

[Guest]

I have a linked table mdb file that has a table named subject matter. I want
to be able to select text from this table. The text describing a subject
matter can be up to 100 characters long. The table is setup as follows:
SubjectMatterID: AutoNumber; SubjectMatter: Text: Filed Size: 255. I have the
row source as: SELECT DISTINCTROW [Br142Subject Matters].* FROM [Br142Subject
Matters] ORDER BY [Br142Subject Matters].[SubjectMatterID];

When I try to enter any subject matter over 50 characters I get the
following message " The field is too small to accept the amount of data you
attempted to add. Try inserting or pasting less data."

So I then tried to use ACC2000: How to use code to change a Field's Data
Type at run time. That did not work. As I remember, the error was related to
my database being linked. I'm using Access 2000.

Any suggestions?

 

[John Vinson]

So I then tried to use ACC2000: How to use code to change a Field's Data
Type at run time. That did not work. As I remember, the error was related to
my database being linked. I'm using Access 2000.

You need to open the *BACKEND* database - the one containing the
tables - and change the field size there. The table definition in your
frontend database is just a link to the backend; you can't change the
properties of a field there, only in the actual table that it points
to.

John W. Vinson[MVP]