Google Answers Logo
View Question
Q: Formatting in Access ( Answered,   1 Comment )
Subject: Formatting in Access
Category: Computers
Asked by: sjkistler-ga
List Price: $5.00
Posted: 21 May 2003 16:52 PDT
Expires: 20 Jun 2003 16:52 PDT
Question ID: 207061
Is it possible to format text in access within a single cell beyond
just caps and smalls? And, if it is possible, then how do you do it?
Specifically, I wish to be able to indent and bold so that when a
query returns the contents of a cell for someone it is more readable.

Request for Question Clarification by hammer-ga on 22 May 2003 04:25 PDT
Which version of Access? 
Where is the "cell"? Query results? Table? Table Form View?

- Hammer

Clarification of Question by sjkistler-ga on 22 May 2003 07:41 PDT
Ideally, I want the formatting to show up whenever and however you
access the cell. I need SOME of the words to be bold and some indented
(tabbed). This should appear when you look at the cell in datasheet
view, when you look at it as part of a report, or when you look at it
as part of a query. I don't think it can be done, but I thought I
would see if someone out there knew how. I know how to format the
entire cell in any way that I want, but not portions within a cell.

Am using Access 2000, 9.0.2720.

Clarification of Question by sjkistler-ga on 22 May 2003 10:21 PDT
I have been through the tutor, through the help, and through two
reference books. I am a mid-level user. I truly don't think that this
can be done, but want someone who is an expert to tell me so. I could
be looking in the wrong section of any one of these behemoth
Subject: Re: Formatting in Access
Answered By: hammer-ga on 22 May 2003 10:38 PDT
Can't be done. You can set formatting for the entire cell value in
some places, but nowhere can you only format part of the value. There
is an add-in that allows you to have Rich Text Format memo controls on
your Access Forms and Reports, but that won't help you in Tables or
Queries. Sorry...

Total Access Memo

- Hammer
Subject: Re: Formatting in Access
From: mmyjuly-ga on 22 May 2003 00:39 PDT
Access has a very helpful interactive tutor for beginning, and
advanced use.  If it is not available on your version of Access, you
can probably download it from the Microsoft site.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy