Custom Formatting

[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

 

[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

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.

 

[Ayo]

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

 

[fredg]

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

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

 

[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?