Changing the Format of a field on a report.

[Tony]

Good Day,

Request a little assistance. Does anyone know how to change the format (appearance) of a field containing a number (i.e., acct # 1234-678-9123) so that it appears like this; xxxx-xxx-9123 or 9123 on a report?

Thank You.

 

[pbaldy]

You could use

Right(FieldName, 4)

to display only the last 4 digits.

 

[Tony]

Pbaldy,

Thanks for the reply. Could you elaborate a bit more though. Where exactly will I be placing the code and how. Appreciate your help.

Thanks,

Tony

 

[pbaldy]

You could use it to create a new field in the query underlying the report:

NewField: Right(FieldName, 4)

or directly in a textbox on the report:

=Right(FieldName, 4)

 

[Tony]

PBaldy,

-I created a new Text Box in the report.

-Selected the Tex Box and Placed the following code, =Right([Acct],4) in its Control Source of the property sheet.

-Replaced the "FieldName" with "Acct".

-Works GREAT! Thank You.

Tony