Adding Punctuation to Text Box

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
 
K

Katrina

=[fieldname] &",

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

=[Fieldname] & ","

Kat
 
R

Rick B

= "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
 
J

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
Click to expand...


.
Click to expand...
 
F

fredg

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
Click to expand...


.
Click to expand...
Click to expand...

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.
 
M

Marshall Barton

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?
Click to expand...


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