Memo Field in form clipping 1

[bcooler]

I am having problems with my memo field not showing all data. Now, I have done the searches and found a few things I'll mention here:

1.) There was a SELECT DISTINCT that clipped the info in the query. After removing this, all the data is showing up in the underlying query. However, the field is still clipped in the form.

2.) There are no format modifiers in the table, form , or query. Since I get the info in the query, I would suspect the problem is how I get the info from the query to the form. Note that I am using Rich Text formatting in both the table and form so I can show "bullets". There are also no other fancy things going on here (see Allen Browne's note in this).

Some other things to note:

I populate this memo field via a connection to a combobox (control =[cboRMA].[Column](9)). This combobox rowsource is driven by a query. However, If I directly link the field outside the query and pull directly from the record source, I correctly get the whole memo field. Unfortunately, I use this form for a dual purpose (initialy entry and edit). On initial entry, I don't get anything in the memo field after entering the combobox (I guessing because the query hasn't been updated since the combobox was entered). On edit I do see the whole field.

I'm looking for a way to populate the whole memo field in both the intial entry and edit mode of the form.

 

[formerTexan]

Have you checked your combobox to see if all of the data is appearing?

debug.print Me.cboRMA.Column(9)

If you are being shortchanged here, then work back another step and see what is showing in the combobox's recordsouce.

Cheers, Bill

 

[dhookom]

A combo box column will never return more than 255 characters. You may be able to use DLookup() or some other method to get more than 255.

Duane
Hook'D on Access
MS Access MVP

 

[bcooler]

Great thought about the column max. I think that's exactly what's going on. I'll try the dlookup