Why are not all symbols in Word accepted in an Access text field?

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

Guest

How can I include a symbol in an access text field without changing it to an
OLE object. Example: The following sentence is to be placed in a text or memo
field in access. "if angle 1= 50 degrees, what is the complement of the
angle?" There is an angle symbol in Word but it will not be accepted by
Access. How can I make that happen? How do i reprogram a character so it will
be displayed in an access text field?
 
How can I include a symbol in an access text field without changing it to an
OLE object. Example: The following sentence is to be placed in a text or memo
field in access. "if angle 1= 50 degrees, what is the complement of the
angle?" There is an angle symbol in Word but it will not be accepted by
Access. How can I make that happen? How do i reprogram a character so it will
be displayed in an access text field?
Click to expand...

Did you try copying the character from Word and pasting it into your
Access text?

Is the angle this "›" ?
Hold down the Alt key and press 0155 in the number keypad.
or this one "‹" "
Hold down the Alt key and press 0139 in the number keypad.
Note: You must use the number keypad, not the numbers on the keyboard.

Open the Character Map program that ships with Windows...
Start + Accessories + System Tools + Character Map

Type Angle (after selecting your Font Style) in the Search text box.
All of the Angle characters will display (my Arial shows 4). Select
the one you want.
The Keystrokes for that character will display at the bottom of the
dialog.

if › 1= 50° (the degree is Alt + 0176)
 
Larry S said:
How can I include a symbol in an access text field without changing it to
an
OLE object. Example: The following sentence is to be placed in a text or
memo
field in access. "if angle 1= 50 degrees, what is the complement of the
angle?" There is an angle symbol in Word but it will not be accepted by
Access. How can I make that happen? How do i reprogram a character so it
will
be displayed in an access text field?
Click to expand...

It is possibly only a matter of using the same font. Through Access 2003,
Text Boxes in Access do not allow formatting, other than selecting the Font,
Size, Boldness, and Italic for the entire Text Box ("rich text" formatting
is supported in Access 2007 Text Boxes). If you have different fonts, or
other formatting in only parts of the text, you will need to find and use a
"Rich Text Box"... I believe a free one is available at MVP Stephen Lebans'
site, http://www.lebans.com but I am not sufficiently familiar with it, nor
do I understand your situation well enough to say whether it will fill your
needs.

Larry Linson
Microsoft Access MVP
 
Back
Top