columns in queries

[hotplate]

Hello,
I am using a combo box to select a value, and column 2 and column 3
poplulate other fields on my form. Column 3 poplulates a field which
is ia memo format, but whenever I select a value, only the first 255
letters of the memo fill the field. What am I doing wrong?
Thanks,
James

 

[Guest]

Trying to use a memo field as a column in a combo. It will always truncate
to the first 255 characters.

 

[John Vinson]

Hello,
I am using a combo box to select a value, and column 2 and column 3
poplulate other fields on my form. Column 3 poplulates a field which
is ia memo format, but whenever I select a value, only the first 255
letters of the memo fill the field. What am I doing wrong?
Thanks,
James

Trying to store redundant data in your table in the first place!

Access Combo Boxes are of limited size; Memo data could (potentially)
be up to two billion bytes per record. It won't FIT in a combo box;
Access trims it to 255 bytes.

And - more critically - it sounds like you're trying to make a
redundant duplicate copy of the data in this memo field. That's almost
certainly *not* a good idea. Relational databases use the
"Grandmother's Pantry Principle" - "a place, ONE place, for
everything; everything in its place". Store the memo field once, and
once only; then use Queries to link to it to display the data in the
memo field.

John W. Vinson[MVP]

 

[hotplate]

How else can I fill this field if I can't use a combo box query without
truncating?