By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Formatting scientific names

P: n/a
I am assembling a database of scientific names, e.g. Acer saccharum
Marshall, sugar maple. The first two elements (genus and species)
should be italicized in the report, the third element (author) should
not. The three elements of the name, genus, species and author, are
in individual fields. I can create the complete scientific name in
the report by concatenating the three fields, but then I cannot format
its parts separately. I've also tried to trick the report into
printing the formatted field contents without white space, but without
success.

This is my first post, and I'd be grateful for any help on this (I'm
sure) elementary question.

May 8 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<pe*****@buffalostate.eduwrote in message
news:11**********************@e51g2000hsg.googlegr oups.com...
>I am assembling a database of scientific names, e.g. Acer saccharum
Marshall, sugar maple. The first two elements (genus and species)
should be italicized in the report, the third element (author) should
not. The three elements of the name, genus, species and author, are
in individual fields. I can create the complete scientific name in
the report by concatenating the three fields, but then I cannot format
its parts separately. I've also tried to trick the report into
printing the formatted field contents without white space, but without
success.
This is my first post, and I'd be grateful for
any help on this (I'm sure) elementary question.
What help, exactly, do you want? Text boxes in Access (through Access 2003)
do not allow formatting of anything less than all the text they contain.
And, while it is possible to calculate the text metrics, it isn't easy.
There are third-party controls allowing text formatting, including a free
one from MVP Stephen Lebans, http://www.lebans.com.

And, standard Access text boxes have additional formatting capabilities in
Access 2007.

Larry Linson
Microsoft Access MVP
May 9 '07 #2

P: n/a
Before you consider using an RTF control, have a look at this solution.
http://www.lebans.com/mixbold-plain.htm
Lady.zip is a database containing functions to allow the developer to mix
Bold and Plain formatting within a single Control. Demonstrates how to use
the Print method of the Report object..NEW - Feb. 18/2000

A97andA2kClaudio.zip are databases containing functions to allow the
developer to mix Bold and Plain formatting within a single Control. This is
an extension/modification to the original Lady.zip. Author Luiz Claudio
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

<pe*****@buffalostate.eduwrote in message
news:11**********************@e51g2000hsg.googlegr oups.com...
>I am assembling a database of scientific names, e.g. Acer saccharum
Marshall, sugar maple. The first two elements (genus and species)
should be italicized in the report, the third element (author) should
not. The three elements of the name, genus, species and author, are
in individual fields. I can create the complete scientific name in
the report by concatenating the three fields, but then I cannot format
its parts separately. I've also tried to trick the report into
printing the formatted field contents without white space, but without
success.

This is my first post, and I'd be grateful for any help on this (I'm
sure) elementary question.

May 9 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.