Personal information formating??

[Ron S]

Good Morning,

I have a report with several phone numbers in it; what I would like to
be able to do I format the phone number to ***-***-1234 when printed so
when these reports get distrubuted the wrong people don't get ahold of
this personal information.

Thanks,

Ron

 

[Rick B]

One way would be to add an unbound text field to the report (instead of the
bound phone field) and put the following in it's source...

="***-***-" & Right([PhoneNumber],4)

You, of course, would replace "PhoneNumber" with the name of your field.

You may want to wrap the entire statement in a "IsNull" type of statement so
that you don't get asterisks if there is no phone number for a given record.

 

[Ron S]

One way would be to add an unbound text field to the report (instead of the
bound phone field) and put the following in it's source...

="***-***-" & Right([PhoneNumber],4)

You, of course, would replace "PhoneNumber" with the name of your field.

You may want to wrap the entire statement in a "IsNull" type of statement so
that you don't get asterisks if there is no phone number for a given record.

--
Rick B

Good Morning,

I have a report with several phone numbers in it; what I would like to
be able to do I format the phone number to ***-***-1234 when printed so
when these reports get distrubuted the wrong people don't get ahold of
this personal information.

Ron- Hide quoted text -- Show quoted text -

I tried this one and for some reason the report did not like it, it
just displayed the expression...

 

[Rick B]

Post what you put in the source for your control.

--
Rick B

One way would be to add an unbound text field to the report (instead of
the
bound phone field) and put the following in it's source...

="***-***-" & Right([PhoneNumber],4)

You, of course, would replace "PhoneNumber" with the name of your field.

You may want to wrap the entire statement in a "IsNull" type of statement
so
that you don't get asterisks if there is no phone number for a given
record.

--
Rick B

message

Good Morning,

I have a report with several phone numbers in it; what I would like to
be able to do I format the phone number to ***-***-1234 when printed so
when these reports get distrubuted the wrong people don't get ahold of
this personal information.

Ron- Hide quoted text -- Show quoted text -

I tried this one and for some reason the report did not like it, it
just displayed the expression...

 

[Ron S]

Post what you put in the source for your control.

--
Rick B

One way would be to add an unbound text field to the report (instead of
the
bound phone field) and put the following in it's source...
="***-***-" & Right([PhoneNumber],4)
You, of course, would replace "PhoneNumber" with the name of your field.
You may want to wrap the entire statement in a "IsNull" type of statement
so
that you don't get asterisks if there is no phone number for a given
record.
--
Rick B
message
Good Morning,
I have a report with several phone numbers in it; what I would like to
be able to do I format the phone number to ***-***-1234 when printed so
when these reports get distrubuted the wrong people don't get ahold of
this personal information.
Thanks,
Ron- Hide quoted text -- Show quoted text -

I tried this one and for some reason the report did not like it, it
just displayed the expression...- Hide quoted text -- Show quoted text -

Thanks for your help -- I got through some red tape and we have
decided that we are going to display the full phone number after all.
Thank you again, your help is really appreciated.

Ron