M
murtexslc
I need to trim the first three characters of a text field when printing to a
report.
report.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
fredg
I need to trim the first three characters of a text field when printing to a
report.
Use an unbound control.
Set it's control source to:
=Mid([FieldName],4)
M
murtexslc
i tried this and keep getting #errors on the report. the text field is being
aquired from a query if that makes any difference.
aquired from a query if that makes any difference.
fredg said:I need to trim the first three characters of a text field when printing to a
report.
Use an unbound control.
Set it's control source to:
=Mid([FieldName],4)
M
Marshall Barton
Make sure the control has a different name than the
fieldname.
--
Marsh
MVP [MS Access]
fieldname.
--
Marsh
MVP [MS Access]
i tried this and keep getting #errors on the report. the text field is being
aquired from a query if that makes any difference.
fredg said:Use an unbound control.
Set it's control source to:
=Mid([FieldName],4)