How to display memo fields on forms.

jasmin_m

New member
Local time
Today, 22:47
Joined
Jan 10, 2010
Messages
8
How to display memo fields on forms.

How can we display memo filed, with his all huge content
in textbox and in list box.
 
You can't do this in a Listbox, it'll be limited to the first 256 characters.

In a textbox you'll need to "zoom" it to show the content. Assuming you're working with a Single View Form (where one record at a time is visible) which is really the only way a record with a memo field should be displayed, this will do it:

Code:
Private Sub YourControl_GotFocus()
  DoCmd.RunCommand acCmdZoomBox
End Sub
 

Users who are viewing this thread

Back
Top Bottom