-
1
- #1
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
