Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formatting text in a field

Status
Not open for further replies.

misscrf

Technical User
Jun 7, 2004
1,344
US
This is probably a new one, so hold on to your boots!

I have users working with a database that holds biographies of people. The different fields hold things like education, full bios, activities, etc.

For example, the full bios needs to be able to be formatted for each record individually. I.E. My bios has text that say 'I went to college' and we want that underlined. It also has text further on in that same field that says 'I have two cats' which we want italicized. For another person's record the field with have completely different text and require different formatting.

What I am looking for is the best possible solution. This may be HTMl coding in the field, it may be mail merge ( but that will probably require a lot of manual work and the goal is to keep the data maintained in the database), there may be other solutions. Got any?

Can html coding work in an Access field to an Access report, are there any other ways to accomplish this?

Thanks all!

misscrf

Management is doing things right, leadership is doing the right things
 
You could possibly use a rich text control like the one at
Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]
 
Thanks. I have convinced the users to just have separate word files and to maintain them separately. Access is not meant to do what they want, and I explained that to them enough to convince the masses. :-D
Whew to that headache!


misscrf

Management is doing things right, leadership is doing the right things
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top