How can I print part of a field?

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.
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print First Character of 30 Byte Field on Report 3
Field size in reports 3
Assigning print date / batch number to reports & invoices 6
How do I write the print date on data row? 4
Field Not Printing 6
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
access 2010 date field 3
Printing attachments with Reports 3

Top