Text Formatting

[js22]

Hello,

I have a question about formatting a text box. I am building a database for the chemistry lab that I work in. We want to keep track of our chemical inventory.

I have a field in my database for entering in the chemical formula. I would like to format the field so that whenever a number is typed into the field it is always a subscript. I don't want any letters to be subscripts, just numbers. I'm not sure if this is possible but if anyone has an idea it would help me out a lot.

thanks

js22

[Fitch]

Substitute(yourField;

["1" ; TextStyleAdd("1"; Subscript)];

["2" ; TextStyleAdd("2"; Subscript)];

["3" ; TextStyleAdd("3"; Subscript)];

etc.

)

I imagine you'll want this to be an auto-entry field that replaces existing data.

Keep in mind that this does not alter the underlying data, only the way it's displayed. If you export the field it will be unformatted.