In a printed Access report can I Trim characters?

B

Brenda

Does anyone know how to I may able to Trim characters from a field in my
Access report?

I have a field with information for which I would like to eliminate the
first 8 characters to the left when printed on paper and print only
everything to the right of those first 8 characters in my report.

Any help would be greatly appreciated!
 
A

Arvin Meyer [MVP]

I would do this in the underlying query that is the recordsource of the
report. Create a column something like:

NewField: Mid([FieldName],9)

Will start with the 9th character and give you all the remaining characters.
 

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

Top