How can I print part of a field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I specify in a report definition that I want to print part of a
field? For example, I have a 10 byte field of which I only want 5 bytes
printed.
 
To print the left 5 characters from Field1, set the ControlSource of your
text box to:
=Left([Field1],5)

Use Mid() or Right() for other characters.

Note that the Name of this text box cannot be the same as a field name.
Access gets confused if the control has the same name as a field, but it
bound to something else.
 
Back
Top