A Forms textbox size

[Guest]

Does an unbound textbox placed on a form have limit to it's size of 255
characters. If so what do i use on a form to display a table's memo field
that is greater that 255 characters.

I have a combobox on a form that is linked to a table. The cbo displays one
field, a place name, on the form and then when selected an unbound textbox is
filled with information on the place(from a memo field in the table) in the
cbo_afterupdate event. Trouble is some entries in the memo fields are greater
than 255 chars and don't display in full on the form.

Thanks for your help,
Ian

 

[Damon Heron]

Set the control source of the textbox to the memo field in the table.

Damon

 

[Damon Heron]

This is better....
in the combobox afterupdate event:

Me.Text1 = DLookup("[yourMemoField]", "[yourtbl]", "[yourplacenamefield]=
Combobox.value")

Damon

 

[Guest]

Thanks Damon,

That seems to have sorted it for me.

Ian.

This is better....
in the combobox afterupdate event:

Me.Text1 = DLookup("[yourMemoField]", "[yourtbl]", "[yourplacenamefield]=
Combobox.value")

Damon

Does an unbound textbox placed on a form have limit to it's size of 255
characters. If so what do i use on a form to display a table's memo field
that is greater that 255 characters.

I have a combobox on a form that is linked to a table. The cbo displays
one
field, a place name, on the form and then when selected an unbound textbox
is
filled with information on the place(from a memo field in the table) in
the
cbo_afterupdate event. Trouble is some entries in the memo fields are
greater
than 255 chars and don't display in full on the form.

Thanks for your help,
Ian