I have a form that pulls a name from a table.

In Table it is in this format: "John Smith"

in the report it shows "John Smith"

I want to make it just display "John S"
on the report for privacy issues.

I've looked into input masks and display format but I cannot come up with anything.

In the table it has to still say "John Smith" as well. Thanks in advance!

-Q

I would suggest you adjust your table so you have firstname and lastname as 2 different fields. It would make your life much easier.

Do you base your report off of query?

You know I already have those fields, you'd think i would have thought of that. Yes it's based off of a query, and yes it would be super easy for me to modify it a bit. Thanks for the help.

it is still bugging me, is that type of display mask possible? aside from having it in separate boxes?

IF its in a query, you can do something like

AbbrevName: Left([personsname],InStr([personsname]," ")+1)

OR if you have it in 2 seperate fields

AbbrevName: [firstname] &" "& left([lastname],1)

You know I already have those fields, you'd think i would have thought of that.

How would i know what you have done? You said its in a table as "John Smith"

well... your not really supposed to it was one of those, "God I'm an idiot" moments...

well... your not really supposed to it was one of those, "God I'm an idiot" moments...


Ah I'm sorry, I mistook your statement to mean that I should have known you would have done that already! ;)