How to display a meno datatype in a text box

[Paul Mak]

I need to display a meno datatype in a text box and I do not want to display
the entire contene of it, Instead I would like to show the first 75
characters of it with three "..." at the end. Thanks.

 

[Janet Russell]

Create an unbound text box and make the Control source the
following:

=Left([name of memo field],75)&"..."

Replace "name of memo field" with the name of your memo
field.

 

[jay Bukstein]

If the field is an unbound database field just set the
control source to =Left([fieldname],75)

For a bound textbox I think the Format property is where
you need to set the number of characters to show.

 

[Steve Schapel]

Paul,

Type the equivalent of this in the Control Source property of the
textbox:
=Left([YourMemoField],75) & " ..."

- Steve Schapel, Microsoft Access MVP