Thread: Fill part of record with asterisk

Hey guys. I'm learning access now and need your help for the folowing

I have created a report using the wizard and added several fields from a table. I need make the report display one of those fields as the folowing

example1 would display as ex************
aster1 as as************

Basically, I need it to disaplay the first character as it is and fill the rest of the record by exactly 12 asterisks.
I'm sorry If i didn't explained correctly, I just starting with access.
Thanks guys

If I understand correctly, you want a particular field to display the first two characters of the field and then 12 asterisks.

I would suggest that you make sure that the record source for the report be a query, for the particular report field you will need to create an expression in your query.

The field would look like this: NewFieldName: Left([OldFieldName],2)&"************"

Use the new field name in your report instead of the old field name.

HTH
Alan

You are welcome.
Alan