Adding Punctuation to Text Box

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to automate a letter that is sent out of my
dept. daily. However adding a comma to the end of my Dear
So and So is giving me problems. I have tired the
following syntax: =[fieldname] &", I have also tired
other similar versions of this syntax with no luck.
Thanks for any assistance you can give.

John
 
= "Dear " & [fieldname] & ", "


Rick B

I am trying to automate a letter that is sent out of my
dept. daily. However adding a comma to the end of my Dear
So and So is giving me problems. I have tired the
following syntax: =[fieldname] &", I have also tired
other similar versions of this syntax with no luck.
Thanks for any assistance you can give.

John
 
I have tired this solution but get an #Error as a response
in my report. What the Heck is wrong with this stupid
thing?
-----Original Message-----
=[fieldname] &",

??
Do you have an ending " after the comma?

=[Fieldname] & ","

Kat

I am trying to automate a letter that is sent out of my
dept. daily. However adding a comma to the end of my Dear
So and So is giving me problems. I have tired the
following syntax: =[fieldname] &", I have also tired
other similar versions of this syntax with no luck.
Thanks for any assistance you can give.

John


.
 
I have tired this solution but get an #Error as a response
in my report. What the Heck is wrong with this stupid
thing?
-----Original Message-----
=[fieldname] &",

??
Do you have an ending " after the comma?

=[Fieldname] & ","

Kat

I am trying to automate a letter that is sent out of my
dept. daily. However adding a comma to the end of my Dear
So and So is giving me problems. I have tired the
following syntax: =[fieldname] &", I have also tired
other similar versions of this syntax with no luck.
Thanks for any assistance you can give.

John


.

John,
=[Fieldname] & ","
is correct. Your probably getting an #error because the control name
is the same as the name of the field. A control cannot have the same
name as the name of a field used in it's control source expression.
Simply change the control name.
 
John said:
I have tired this solution but get an #Error as a response
in my report. What the Heck is wrong with this stupid
thing?


Make sure the text box is named something other than the
fieldname.
 
Back
Top