Adding a "." to the end of a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a report, i'm trying to add a ".", at the end of a field with a phone
number input mask. I've tried several things to no avail. Any help would be
greatly appreciated.

I'm trying to make it appear as follows:

If you have any questions, please feel free to contact me at (Phone Number).

Thanks in advance for your help
 
Scott

Since you are working in a report, you don't need to mess with the data to
get that done.

In a control that will hold your message, type the following into the
Control Source property:

= "If you have any questions, please feel free to contact me at " &
[YourPhoneField] & "."

This will concatenate the sentence and punctuation on the value of the
field.

On the other hand, if you are asking them to call YOU, won't your phone
number always be the same?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have added in a text box control field ="If you have any questions,
please feel free to contact me at " & [phone] & "."

When I view the report it has "#error" where the field should be located.

It will be a different phone # depending on who sent the memo.

Thanks for your assistance.
--
Scott


Jeff Boyce said:
Scott

Since you are working in a report, you don't need to mess with the data to
get that done.

In a control that will hold your message, type the following into the
Control Source property:

= "If you have any questions, please feel free to contact me at " &
[YourPhoneField] & "."

This will concatenate the sentence and punctuation on the value of the
field.

On the other hand, if you are asking them to call YOU, won't your phone
number always be the same?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Scott said:
On a report, i'm trying to add a ".", at the end of a field with a phone
number input mask. I've tried several things to no avail. Any help would
be
greatly appreciated.

I'm trying to make it appear as follows:

If you have any questions, please feel free to contact me at (Phone
Number).

Thanks in advance for your help
Click to expand...
Click to expand...
 
That should be in the text box's Control Source property. I'm not sure if
that's what you mean by "control field".
Is [phone] available as the control source for the text box? If not, the
problem is that the field is not in the report's record source. If so, do
you get the correct phone number if you select it as the control source for
the text box?

Scott said:
I have added in a text box control field ="If you have any questions,
please feel free to contact me at " & [phone] & "."

When I view the report it has "#error" where the field should be located.

It will be a different phone # depending on who sent the memo.

Thanks for your assistance.
--
Scott


Jeff Boyce said:
Scott

Since you are working in a report, you don't need to mess with the data
to
get that done.

In a control that will hold your message, type the following into the
Control Source property:

= "If you have any questions, please feel free to contact me at " &
[YourPhoneField] & "."

This will concatenate the sentence and punctuation on the value of the
field.

On the other hand, if you are asking them to call YOU, won't your phone
number always be the same?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Scott said:
On a report, i'm trying to add a ".", at the end of a field with a
phone
number input mask. I've tried several things to no avail. Any help
would
be
greatly appreciated.

I'm trying to make it appear as follows:

If you have any questions, please feel free to contact me at (Phone
Number).

Thanks in advance for your help
Click to expand...
Click to expand...
Click to expand...
 
I ended up just cheating, and added a new field for it on the table. Then
did an update query to merge everything together. Then on the report, i just
pulled in the new field. Thanks everyone for all of their help.
--
Scott


BruceM said:
That should be in the text box's Control Source property. I'm not sure if
that's what you mean by "control field".
Is [phone] available as the control source for the text box? If not, the
problem is that the field is not in the report's record source. If so, do
you get the correct phone number if you select it as the control source for
the text box?

Scott said:
I have added in a text box control field ="If you have any questions,
please feel free to contact me at " & [phone] & "."

When I view the report it has "#error" where the field should be located.

It will be a different phone # depending on who sent the memo.

Thanks for your assistance.
--
Scott


Jeff Boyce said:
Scott

Since you are working in a report, you don't need to mess with the data
to
get that done.

In a control that will hold your message, type the following into the
Control Source property:

= "If you have any questions, please feel free to contact me at " &
[YourPhoneField] & "."

This will concatenate the sentence and punctuation on the value of the
field.

On the other hand, if you are asking them to call YOU, won't your phone
number always be the same?

Regards

Jeff Boyce
Microsoft Office/Access MVP

On a report, i'm trying to add a ".", at the end of a field with a
phone
number input mask. I've tried several things to no avail. Any help
would
be
greatly appreciated.

I'm trying to make it appear as follows:

If you have any questions, please feel free to contact me at (Phone
Number).

Thanks in advance for your help
Click to expand...
Click to expand...
Click to expand...
 
Back
Top