How to display a meno datatype in a text box

  • Thread starter Thread starter Paul Mak
  • Start date Start date
P

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.
 
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.
 
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.
 
Paul,

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

- Steve Schapel, Microsoft Access MVP
 
Back
Top