On Change command truncates memo field.

[jlindquist23]

I'm using a Combo Box with an On Change event to fill in data in my form.


There is one field that is a long memo field. When the data for the memo field is populated, it gets truncated.

The memo field in the query I'm using to fill the data is not truncated.

All the data formats are set to Rich Text for the table it is coming from and the table it is going to.
The field it is going to is also formatted to a Can Grow state JIC.

Am I missing something?

[June7]

Exactly how are you using combobox to accomplish this? A combobox column is limited to 255 characters.

[jlindquist23]

Me.txtSageMemo.Value = Me.cboItemNo.Column(27)
Is there another way to accomplish this and not use a combo box?

[June7]

As I said, combobox column limited to 255 characters, or so I thought. I count 250 characters/spaces in truncated string.

Why duplicate data? Maybe have a table of these unique strings and just save record ID.

Otherwise, use DLookup() to pull full string from memo field.

[Micron]

I'm using a Combo Box with an On Change event to fill in data in my form.

Not really what they're for.

When the data for the memo field is populated, it gets truncated.

I'd wager that the image represents 255 characters (including any hidden ones)
Can grow only refers to physical size, not content limits
Do you realize that OnChange fires on every key press? Usually reserved for situations such as' find-as-you-type'

[jlindquist23]

Can you help with the DLookup formula? I haven't used that one...

Control Source: SageMemo is where I want the data to appear in the HTRecord form (Name txtSageMemo).
SAGE_RCHardnessByPNQry is where the data is pulling from.
Field name in that Query is UDF_HT_MEMO
I'd like it to display for the current record int the HTRecord form

Does this do that?
DLookup("[SageMemo]", "[SAGE_RCHardnessByPNQry]", "[ItemNo]. [SAGE_RCHardnessByPNQry]", " & Forms![HTRecord]![txtSageMemo])

[June7]

What is the form's RecordSource?

Syntax not quite right. Does txtSageMemo have value for ItemNo? Is ItemNo a number field? Shouldn't you reference combobox for the record identifier?

Can put the expression in textbox ControlSource property:

=DLookup("[UDF_HT_MEMO]", "[SAGE_RCHardnessByPNQry]", "[ItemNo]=" & Forms![HTRecord]![txtSageMemo])

However, saving this retrieved value into record will require code (macro or VBA) in an event, possibly combobox AfterUpdate:

Me.SageMemo = DLookup("[UDF_HT_MEMO]", "[SAGE_RCHardnessByPNQry]", "[ItemNo]=" & Forms![HTRecord]![txtSageMemo])

[jlindquist23]

The forms record source is Joined_Qry
Every ItemNo does have a SageMemo
ItemNo is a text field.
combo box name is cboItemNo, control source is ItemNo.

Thank you for helping me sort this out btw!!

[June7]

Then modify:

DLookup("[UDF_HT_MEMO]", "[SAGE_RCHardnessByPNQry]", "[ItemNo]='" & Forms![HTRecord]!cboItemNo & "'")

I still wonder why save full memo value. If you save ItemNo then should be able to retrieve associated memo value in query joining tables.

An alternative to DLookup (domain aggregate functions can cause slow performance) may be to include table with memo in the form RecordSource (don't use INNER JOIN). Bind textbox to the memo field and set it as Locked Yes and TabStop No to prevent edit.