Display text in a Text box.

[Xiazer]

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

 

[rainman89]

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?

 

[Xiazer]

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?

 

[rainman89]

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)

 

[rainman89]

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"

 

[Xiazer]

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

 

[rainman89]

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!