Suggestions for exponents?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil F - 31 Jul 2007 08:18 GMT

Hi -

I have a field that holds the "units" of a measurement as a string. It can
be something like "kg" for kilograms or "m^2" for meters-squared. The folks I
am working with keep asking if there is a way to display the latter with a
superscript, as in m2 (with the "2") being a smaller font and higher. I know
of no way to do this short of using two string fields on a form, and managing
that seems kind of daunting.

Has anyone dealt with this before and have any suggestions?

Thanks in advance,

Phil Freihofner

Reply to this Message

scubadiver - 31 Jul 2007 13:16 GMT

A text box is just that!

What is the purpose?

Signature

www.ae911truth.org

> Hi -
>
[quoted text clipped - 10 lines]
>
> Phil Freihofner

Reply to this Message

Douglas J. Steele - 31 Jul 2007 13:17 GMT

See whether holding down the Alt key and keying 0178 on the number pad
works: that's how I just did m². (note that it can depend on what font
you're using)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi -
>
[quoted text clipped - 13 lines]
>
> Phil Freihofner

Reply to this Message

Phil F - 31 Jul 2007 21:38 GMT

Thank you!

For some reason I overlooked where you wrote "number pad" and was dismayed
at first when the numbers above the letters did not work. So I thought I
would just add that for anyone else who happens to do a search here for
"exponents" or "superscripts".

I've since discovered my users are also using exponents such as m^6 and m^8.
Tt seems it will take a bit more work to uncover those control sequences. The
Access version here on site doesn't have help installed, or I would also add
that reference to this note.

- Phil Freihofner

> See whether holding down the Alt key and keying 0178 on the number pad
> works: that's how I just did m². (note that it can depend on what font
[quoted text clipped - 17 lines]
> >
> > Phil Freihofner

Reply to this Message

Douglas J. Steele - 01 Aug 2007 12:20 GMT

Unfortunately, the "number pad" approach is limited to ² and ³.

There's really no simple solution to what you want. You could use an RTF
control, but you'd have to create an interface that allows your users to
create the text correctly.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Thank you!
>
[quoted text clipped - 36 lines]
>> >
>> > Phil Freihofner

Reply to this Message

scubadiver - 31 Jul 2007 13:26 GMT

Ignore my first response. Douglas is correct.

Just to add something further you may be able to press a button in the form
that will add the superscript automatically. Worth a think instead of doing
ALT+0178 every time!

> Hi -
>
[quoted text clipped - 10 lines]
>
> Phil Freihofner

Reply to this Message