GURU NEEDED!!! Query memo field for user selection in report

[ausced]

I wasn't able to find anyone with a similar problem to this one - so,
I'm hoping one of you guru's can give me some direction on this.

I have a form that runs off a query and populates a table. The
purpose of this form is for general data entry. At the end of the
form, the user uses a combo box to select a report. This report is
designed to appear like a letter and all of the data entered in the
form merges into this report/letter.

Here's my first problem. The combo box lists brief reasons for which
the letter is being sent:

Example:
Field One Field Two
Participation We are unable to process your claim due to low
participation.

This combo box pulls from a query based on a table in which Field Two
is a memo field. The combo box shows "Field One", but is bound to
"Field Two" so that it can be merged into the report. This is fine,
except that since the data from the query is then being merged into
the report, if the field is larger than 255 characters, it cuts it
off. This is not a DISTINCT query. Also, this cannot be a grouped
query (so I cannot change Group By to First) because when I tried to
change it to a grouped query, the combo box would not allow
selections.

I'm not sure if there's a solution to this problem, but I would
appreciate any advice you can offer.

 

[John Spencer]

As far as I know, A column in a combobox or listbox is never more than
255 characters.

If field one is unique then make that the bound column and get the field
two value in your query by including the table with the values in your
report query.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[ausced]

As far as I know, A column in a combobox or listbox is never more than
255 characters.

If field one is unique then make that the bound column and get the field
two value in your query by including the table with the values in your
report query.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

THANK YOU SO MUCH JOHN!!! This is the exact answer I needed for my
situation. I couldn't see the forest for the trees!!! Thanks for
taking me in the right direction with this!