How can I print part of a field?

[steven8264]

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.

 

[Allen Browne]

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.