G Guest Mar 17, 2005 #1 I need to trim the first three characters of a text field when printing to a report.
F fredg Mar 17, 2005 #2 I need to trim the first three characters of a text field when printing to a report. Click to expand... Use an unbound control. Set it's control source to: =Mid([FieldName],4)
I need to trim the first three characters of a text field when printing to a report. Click to expand... Use an unbound control. Set it's control source to: =Mid([FieldName],4)
G Guest Mar 17, 2005 #3 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: I need to trim the first three characters of a text field when printing to a report. Click to expand... Use an unbound control. Set it's control source to: =Mid([FieldName],4) Click to expand...
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: I need to trim the first three characters of a text field when printing to a report. Click to expand... Use an unbound control. Set it's control source to: =Mid([FieldName],4) Click to expand...
M Marshall Barton Mar 17, 2005 #4 Make sure the control has a different name than the 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) Click to expand... Click to expand...
Make sure the control has a different name than the 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) Click to expand... Click to expand...
