memo field not show all

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a small form with 2 combo boxes and a memo field on
it. I select the first combo box and the second will fill
with the filtered info based on the first. These work.
The memo field (txtbox) is them to fill with the verbage
based on the second combo box selection. This is where
the problem enters. The info will display but not all of
it. It seems to cutoff. The table says it is a memo
type. Does any one know why this would occur? I have
others that do not do this and they and this one are made
the same.
Thanks in advance for any assistance.
*** John
 
I have a small form with 2 combo boxes and a memo field on
it. I select the first combo box and the second will fill
with the filtered info based on the first. These work.
The memo field (txtbox) is them to fill with the verbage
based on the second combo box selection. This is where
the problem enters. The info will display but not all of
it. It seems to cutoff. The table says it is a memo
type. Does any one know why this would occur? I have
others that do not do this and they and this one are made
the same.
Thanks in advance for any assistance.
*** John
Click to expand...

If you're trying to fill the memo field by relaying its contents
through the combo box, it will NOT work - you cannot put 2 GByte (or
even 65536 bytes) of data into a Combo box column, it will truncate at
255.

How are you filling the textbox? Could you post your code?
 
What I am doing is typing the info into the memo field.
Then later when the second combo shows an item, the memo
field will display the info that was typed in. But the
info in the memo field is getting cutoff.
 
Here is further information. I looked in the table when I
added a new item and all is there on the table. When I
went back out to the small form it is cutoff. What is on
the form is;
CaptionName - combo1
ControlName - combo2
HelpInfo - txtbox

When the user goes to use it, the combo1 is used to select
the caption, the combo2 populates based the combo1. When
combo2 is selected, the HelpInfo should display. Below is
how the HelpInfo is displayed after combo2 is selected.

Private Sub ControlName_AfterUpdate()
Me.HelpInformation = Me.ControlName.Column(2)

End Sub
 
Back
Top