superscript problem !!!!

[Andy B]

I have created a database which needs to contain various items / formulas which are superscripted such as cm³, °C etc etc.

Now l can find some of what l need on the character map but in other instances what i need is not there.

I have been through the available toolbar buttons but cannot find how to superscript. I have even copied a superscripted formula out of Word but it reverts back to a none superscripted format.

Any ideas as this is seriously compromising my data base.

Regards

Andy B

 

[WayneRyan]

Andy,

I think that Access can store your data, but its native controls won't be
able to display it.

I think your alternatives here are RTF (Rich Text Format) controls, or
do some research for third-party add-in controls that handle it.

Wayne

 

[Pat Hartman]

Standard TextBoxes have a single set of attributes for the entire text string. You could use a superscript font but it would need to apply to the entire control. It might be possible to separate the regular text from the superscript text. You could put the two controls very close together and hopefully it won't look too bad. Or as WayneRyan suggested you can use an RTF control. However, this will be somewhat difficult to work with. The Rtf control's actual text value will contain not only the field value but the tag characters that define superscript. Create a word document that has a superscript character and save the document as .rtf. Then open the .rtf file with notepad. You'll see not only your text but the tags that define the text's attributes.

 

[mresann]

All formulas can be created with ASCII set characters. For instance, your usage of cm³ can be stored as "cm ^ 3", and degrees can be stored as its own variable. However, I take it that you want to be able to display the formatting, not just accomodate the actual calculation, and for that you need to look into third party controls.

I used to know of two or three, but haven't found them although I googled "VB Algebra Display"... you may have better luck.

 

[Andy B]

Superscript Problem !!!!

Thanks for all of your help, after much thought l have limited the superscript to the character map available formatts and with a bit of compromise this seems to have given me a solution.

Once again thanks, as you have all saved me loads of time that l would have spent trying to resolve this issue.

Regards

Andy B