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