In a printed Access report can I Trim characters?

  • Thread starter Thread starter Brenda
  • Start date Start date
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!
 
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.
 
Back
Top