Populating unbound fields in a form.

[jamason07]

Good Afternoon,

I have a dropdown menu which, when an option is selected, populates other unbound fields from the table that the dropdown menu is linked to. However, two of the fields in the linked table are memo fields. When the selection is made, the unbound fields are only populated with the first 255 characters as opposed to everything in that field. Is there a way to correct this so the entire contents populate the field.

Here is my code:

Private Sub cboMetric_AfterUpdate()
Me!MetricNumber.Value = Me!cboMetric.Column(2)
Me!Description.Value = Me!cboMetric.Column(3)
Me!Measurement.Value = Me!cboMetric.Column(4)
Me!IDKey.Value = Me!cboMetric.Column(5)
Me!Validation.Value = Me!cboMetric.Column(6)
Me!MetricGroupNumber = Me!cboMetric.Column(7)

The "Description" and "Measurement" fields are memo fields which have more than 255 characters. Any and all help is appreciated. Thanks!

JAM

 

[PHV]

I'm not sure a combo's column may hold more than 255 chars.
You may try to play with the DLookUp function to populate your textboxes with the memos.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BobJacksonNCI]

Specifications can vary by version.

Per Microsoft, you can find the spec's for your version by:

"You can find all of the database and project specifications by clicking Microsoft Access Help on the Help menu in Microsoft Access, typing specifications in the Office Assistant, and then clicking Search to view the "Access Specifications" topic."

For Access 2000, the maximum number of characters in a text box are 255.


HTH,
Bob