Custom Formatting

A

Ayo

Is it possible to format values to display in a control textbox as follows:

3 degree as 3 with a superscript O
3 dB
3 ft
 
F

fredg

Is it possible to format values to display in a control textbox as follows:

3 degree as 3 with a superscript O
3 dB
3 ft
Click to expand...



Access does not support superscript, except for a very few exceptions.
Those exceptions you can display quite easily.

For the degree
Enter your value first, i.e. 3, then hold down the Alt key and enter
0176 using the number keypad. You will get 3°.
Also a few others, such as Superscript 2 (ALT+ 0178) and Superscript 3
(ALT + 0179), which will return ² or ³.

Take a look in the character map utility that ships with Windows.

Start + All Programs + Accessories + System Tools + Character Map
to learn more about the key codes.
 
F

fredg

Thanks Fred.
What about the the other two formats? How do I display those?
Click to expand...

Exactly the same method. Enter the Value then use the ALT+Number.
5 ALT+0178 will display 5²
5 ALT + 0179 will display 5³
 
A

Ayo

What I meant was that, in Excel you can format a cell to display 3 as "3 dB"
without having to type 3 dB in the cell. How would you do that in Access?
 
Top