Text Box "&" will not show

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

I have run across this a few time, but I can't figure out how to show the &
in a text box.
I am replicating a worker's compensation audit report and I am trying to
make it look as close as possible to the original
In the last line, the label reads:
"Checked by & Date"
It just leaves a blank space, where the & is.
Have not been able find anything in the help.
Annelie
 
Annelie said:
I have run across this a few time, but I can't figure out how to show the &
in a text box.
I am replicating a worker's compensation audit report and I am trying to
make it look as close as possible to the original
In the last line, the label reads:
"Checked by & Date"
It just leaves a blank space, where the & is.
Click to expand...


That's a Label control, not a text box. The & is used to
indicate the keyboard shortcut key for the control. The
character after the & will be underlined as a reminder to
the users. To actually display an & just use two &

"Checked by && Date"
 
The & symbol has a special meaning in Access. In order to
display a *regular* one in a text box/label just double
them up. So use this as the Control Source of the text box:

"Checked By && Date"
 
Try replacing the label field with a text box (ab| toolbox
icon in Access 97)containing the expression ="Checked by "
&"&" & " Date"). You'll want to delete the label for the
text box itself.
HTH
 
Back
Top