H
Hennie
Good Day,
For years I have been frustrated with Access and the inability of creating
reports with chemical formulas where subscript or a formula with superscript
was required. I assume there are several others with the same frustration
as I had. I have stumbled on a solution for this problem and it is a work
around from Microsoft Word as it cannot be done in Access. I have found two
different ways to accomplish this.
There are three different fonts with which superscripts and subscripts can
be achieved. With Office 2007, Calibri and with Office 2003, Lucida Sans
Unicode and Palatino Linotype.
To enter subscripts try the following in Word: Insert\Symbol and find one of
the three mentioned fonts. On the right hand side above the display box
there is a Subset combo box. Find Subscript and Superscript in the list and
insert the letter required. For sulfuric acid H2SO4 insert the two and the
four. Unfortunately the whole formula must be in any of the three fonts.
Copy the formula and transfer to the label's Caption. Alternatively it can
be pasted as an OLEUnbound Object Frame. Using the second method Word's
Superscript/subscript function can be used with any font. The font weight
and size must be done in Word. The only thing I do not know is what effect
it will have down the road.
A second tip to pass along is to create an Input mask for numbers. If you
try to use the input mask wizard on numbers an error message appears saying
"Input Mask Wizard only works with text or date field types". Change the
number field to a text field and complete the process for the number field
including the number of decimals required. Click OK. Using it as a text
field will not permit you to do any calculation on the data. Changing the
field back to numbers and leave the mask in place will give you the required
input mask.
Good luck
Hennie
For years I have been frustrated with Access and the inability of creating
reports with chemical formulas where subscript or a formula with superscript
was required. I assume there are several others with the same frustration
as I had. I have stumbled on a solution for this problem and it is a work
around from Microsoft Word as it cannot be done in Access. I have found two
different ways to accomplish this.
There are three different fonts with which superscripts and subscripts can
be achieved. With Office 2007, Calibri and with Office 2003, Lucida Sans
Unicode and Palatino Linotype.
To enter subscripts try the following in Word: Insert\Symbol and find one of
the three mentioned fonts. On the right hand side above the display box
there is a Subset combo box. Find Subscript and Superscript in the list and
insert the letter required. For sulfuric acid H2SO4 insert the two and the
four. Unfortunately the whole formula must be in any of the three fonts.
Copy the formula and transfer to the label's Caption. Alternatively it can
be pasted as an OLEUnbound Object Frame. Using the second method Word's
Superscript/subscript function can be used with any font. The font weight
and size must be done in Word. The only thing I do not know is what effect
it will have down the road.
A second tip to pass along is to create an Input mask for numbers. If you
try to use the input mask wizard on numbers an error message appears saying
"Input Mask Wizard only works with text or date field types". Change the
number field to a text field and complete the process for the number field
including the number of decimals required. Click OK. Using it as a text
field will not permit you to do any calculation on the data. Changing the
field back to numbers and leave the mask in place will give you the required
input mask.
Good luck
Hennie