super- and sub- script via VBA?

[ajetrumpet]

how about doing it inline with texts? =] Twips to font conversion anyone ... Bueller?

I believe the exact quote should be:

Bueller? ... Bueller? ... Bueller? ... Bueller?

Or was it just 3? Not quite sure!

 

[wiklendt]

thanks dkinley. i don't get missing reference warning when i open the 97 version in 2007, BUT i do get a "covert?" dialog at every step! (also, the target names appear in the print preview, but that whole column is blank in layout view... go figure?)

- oh, and full credit should definitely go to petehilljnr...!

 

[wiklendt]

For the challenge round ... how about doing it inline with texts? =] Twips to font conversion anyone ... Bueller?

you mean using some sort of formatting markup like i had thought about at the beginning? that WOULD be nice, especially if in the future a computer illiterate scientist would need to add more targets... BUT, my job here is done ;-P

 

[dkinley]

Exactly! .... I was thinking about Banana's post of using flags.

My contribitution would be a series of textboxes placed on the report tht that are dynamically spaced for the formatting, etc, so it appears to be inline text. I was working on some other stuff in the past where I was concerned about spacing but was thinking that I would need some sort of twips to font conversion so if you chose font A the conversion algorithm would spell properly space the next text box for sub/super text box and then continue the text with a new text box.

There might be another way ... just what I had in my head.

Thanks again, tho!
-dK

 

[petehilljnr]

That was the original idea for what I was proposing, except without the need for text boxes.
The Print method always hold your place from where the last character was printed, ready to print the next one.
That means you'd only have to reset your Y position (and that's why I had place holders using the Top property as the Y position for super/sub/normal).
Means you could mark up as per original post with perhaps even an evolving set of mark up rules in a seperate table.
It also means you wouldn't have to do a font conversion or anything (though there is TextWidth and TextHeight properties for the Print method).
The only bummer is you can't use this on forms as far as I know. I would be quite nice to test your mark ups in real time, rather than checking the report.

If I get some time this weekend (should do seeing rugby season is over), I'll give it a whack.

Pete.