How do I do display xxx-xx-1234 in an access report

[stressed]

I am trying to 'x' out the first 5 digits of a social security number on a
report and only show the last 4 digits. How do I do this?

 

[Duane Hookom]

Use a control source of:
="xxx-xx-" & Right([SSN],4)
Make sure the name of the control is not the same as a field name.

 

[stressed]

It displays the xxx-xx but not the last 4 digits.

Use a control source of:
="xxx-xx-" & Right([SSN],4)
Make sure the name of the control is not the same as a field name.
--
Duane Hookom
Microsoft Access MVP

I am trying to 'x' out the first 5 digits of a social security number on a
report and only show the last 4 digits. How do I do this?

 

[Duane Hookom]

What did you enter into the control source? What is your field name? If you
place a text box next to this with the SSN field, does it show? Did you make
the text box wide enough?

--
Duane Hookom
Microsoft Access MVP

It displays the xxx-xx but not the last 4 digits.

Use a control source of:
="xxx-xx-" & Right([SSN],4)
Make sure the name of the control is not the same as a field name.
--
Duane Hookom
Microsoft Access MVP

I am trying to 'x' out the first 5 digits of a social security number on a
report and only show the last 4 digits. How do I do this?

 

[stressed]

My field name is SocSec#. I entered ="xxx-xx-" & Right ([SSN], 4). It is
asking me for a parameter value.

What did you enter into the control source? What is your field name? If you
place a text box next to this with the SSN field, does it show? Did you make
the text box wide enough?

--
Duane Hookom
Microsoft Access MVP

It displays the xxx-xx but not the last 4 digits.

Use a control source of:
="xxx-xx-" & Right([SSN],4)
Make sure the name of the control is not the same as a field name.
--
Duane Hookom
Microsoft Access MVP


:

I am trying to 'x' out the first 5 digits of a social security number on a
report and only show the last 4 digits. How do I do this?

 

[Gina Whipp]

Since your field name is SocSec#, you have to replace SSN with your field
name ---> ="xxx-xx-" & Right ([SocSec#], 4)

Also, as Duane mentioned, make sure your field name is not the same as your
control source for said field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

My field name is SocSec#. I entered ="xxx-xx-" & Right ([SSN], 4). It is
asking me for a parameter value.

What did you enter into the control source? What is your field name? If
you
place a text box next to this with the SSN field, does it show? Did you
make
the text box wide enough?

--
Duane Hookom
Microsoft Access MVP

It displays the xxx-xx but not the last 4 digits.


:

Use a control source of:
="xxx-xx-" & Right([SSN],4)
Make sure the name of the control is not the same as a field name.
--
Duane Hookom
Microsoft Access MVP


:

I am trying to 'x' out the first 5 digits of a social security
number on a
report and only show the last 4 digits. How do I do this?

 

[stressed]

I don't think I understand: make sure your field name is not the same as your
control source for said field.
when you say field name are you talking about the table field name which is
SocSEC#? The report column name is social security #.
Thank you.

Since your field name is SocSec#, you have to replace SSN with your field
name ---> ="xxx-xx-" & Right ([SocSec#], 4)

Also, as Duane mentioned, make sure your field name is not the same as your
control source for said field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

My field name is SocSec#. I entered ="xxx-xx-" & Right ([SSN], 4). It is
asking me for a parameter value.

What did you enter into the control source? What is your field name? If
you
place a text box next to this with the SSN field, does it show? Did you
make
the text box wide enough?

--
Duane Hookom
Microsoft Access MVP


:

It displays the xxx-xx but not the last 4 digits.


:

Use a control source of:
="xxx-xx-" & Right([SSN],4)
Make sure the name of the control is not the same as a field name.
--
Duane Hookom
Microsoft Access MVP


:

I am trying to 'x' out the first 5 digits of a social security
number on a
report and only show the last 4 digits. How do I do this?

 

[Duane Hookom]

Quite often a designer will drag a field from the field list onto the report.
By default, the name of the text box will be the same as the field name. If
you then change the Control Source to something like:
="xxx-xx-" & Right ([SocSec#], 4)
you will get an error. You will need to change the control's name so it is
not the same as the name of a field.

--
Duane Hookom
Microsoft Access MVP

I don't think I understand: make sure your field name is not the same as your
control source for said field.
when you say field name are you talking about the table field name which is
SocSEC#? The report column name is social security #.
Thank you.

Since your field name is SocSec#, you have to replace SSN with your field
name ---> ="xxx-xx-" & Right ([SocSec#], 4)

Also, as Duane mentioned, make sure your field name is not the same as your
control source for said field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

My field name is SocSec#. I entered ="xxx-xx-" & Right ([SSN], 4). It is
asking me for a parameter value.

:

What did you enter into the control source? What is your field name? If
you
place a text box next to this with the SSN field, does it show? Did you
make
the text box wide enough?

--
Duane Hookom
Microsoft Access MVP


:

It displays the xxx-xx but not the last 4 digits.


:

Use a control source of:
="xxx-xx-" & Right([SSN],4)
Make sure the name of the control is not the same as a field name.
--
Duane Hookom
Microsoft Access MVP


:

I am trying to 'x' out the first 5 digits of a social security
number on a
report and only show the last 4 digits. How do I do this?

 

[stressed]

when I enter what you have, I get ERROR# in the social security field of the
report.

Since your field name is SocSec#, you have to replace SSN with your field
name ---> ="xxx-xx-" & Right ([SocSec#], 4)

Also, as Duane mentioned, make sure your field name is not the same as your
control source for said field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

My field name is SocSec#. I entered ="xxx-xx-" & Right ([SSN], 4). It is
asking me for a parameter value.

What did you enter into the control source? What is your field name? If
you
place a text box next to this with the SSN field, does it show? Did you
make
the text box wide enough?

--
Duane Hookom
Microsoft Access MVP


:

It displays the xxx-xx but not the last 4 digits.


:

Use a control source of:
="xxx-xx-" & Right([SSN],4)
Make sure the name of the control is not the same as a field name.
--
Duane Hookom
Microsoft Access MVP


:

I am trying to 'x' out the first 5 digits of a social security
number on a
report and only show the last 4 digits. How do I do this?

 

[Gina Whipp]

Stressed,

What is the name of your field in your Report? This information can be had
by going to design view of your report and looking at the Properties for
said field...

Field Name = SocSec# ?????
Control Source = ?????

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I don't think I understand: make sure your field name is not the same as
your
control source for said field.
when you say field name are you talking about the table field name which
is
SocSEC#? The report column name is social security #.
Thank you.

Since your field name is SocSec#, you have to replace SSN with your field
name ---> ="xxx-xx-" & Right ([SocSec#], 4)

Also, as Duane mentioned, make sure your field name is not the same as
your
control source for said field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

My field name is SocSec#. I entered ="xxx-xx-" & Right ([SSN], 4). It
is
asking me for a parameter value.

:

What did you enter into the control source? What is your field name?
If
you
place a text box next to this with the SSN field, does it show? Did
you
make
the text box wide enough?

--
Duane Hookom
Microsoft Access MVP


:

It displays the xxx-xx but not the last 4 digits.


:

Use a control source of:
="xxx-xx-" & Right([SSN],4)
Make sure the name of the control is not the same as a field name.
--
Duane Hookom
Microsoft Access MVP


:

I am trying to 'x' out the first 5 digits of a social security
number on a
report and only show the last 4 digits. How do I do this?

 

[M Skabialka]

If you add the SocSec# field to your report, you will have
Name: SocSec#
Control Source: SocSec#

but if you manipulate the ControlSource, you have to change the NAME of it:
Name: SocSec#Mask
Control Source: ="xxx-xx-" & Right ([SocSec#], 4)

Does this make sense?
Mich

when I enter what you have, I get ERROR# in the social security field of
the
report.

Since your field name is SocSec#, you have to replace SSN with your field
name ---> ="xxx-xx-" & Right ([SocSec#], 4)

Also, as Duane mentioned, make sure your field name is not the same as
your
control source for said field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

My field name is SocSec#. I entered ="xxx-xx-" & Right ([SSN], 4). It
is
asking me for a parameter value.

:

What did you enter into the control source? What is your field name?
If
you
place a text box next to this with the SSN field, does it show? Did
you
make
the text box wide enough?

--
Duane Hookom
Microsoft Access MVP


:

It displays the xxx-xx but not the last 4 digits.


:

Use a control source of:
="xxx-xx-" & Right([SSN],4)
Make sure the name of the control is not the same as a field name.
--
Duane Hookom
Microsoft Access MVP


:

I am trying to 'x' out the first 5 digits of a social security
number on a
report and only show the last 4 digits. How do I do this?