PC Review


Reply
Thread Tools Rate Thread

How can you enter subscripts and superscripts in Access?

 
 
dogleg left
Guest
Posts: n/a
 
      9th Apr 2009
I would like to store information in Access - the data has subsripts and
superscripts that are meaningful. How do I enter these in access? Will access
save them?


 
Reply With Quote
 
 
 
 
Ken Snell MVP
Guest
Posts: n/a
 
      10th Apr 2009
ACCESS 2003 and earlier versions do not have a rich text control/field, so
they cannot store superscripts or subscripts. ACCESS 2007 does have a rich
text control/field, so it will store them.

Stephen Lebans has a rich text control for the earlier versions of ACCESS.
See www.lebans.com website.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"dogleg left" <dogleg (E-Mail Removed)> wrote in message
news:4E641ED1-0DC6-4C2F-A8F5-(E-Mail Removed)...
>I would like to store information in Access - the data has subsripts and
> superscripts that are meaningful. How do I enter these in access? Will
> access
> save them?
>
>



 
Reply With Quote
 
Paul Shapiro
Guest
Posts: n/a
 
      10th Apr 2009
Rich text fields in Access 2007 are severely limited. They support a minimal
subset of html tags, mostly font and paragraph formatting. They do not
support sub and superscripts. Worse than just not displaying the text
correctly in a textbox with TextFormat set to Rich Text, Access sometimes
silently removes the unsupported tags when you edit that data. I resorted to
only allowing data edits with text boxes set to plain text format, so the
user has to edit the tags manually. Displaying the data in a form works
correctly in a web browser control, which supports all html tags, but that
control does not have a CanGrow property so it's not of much use in reports.
In that case I use a rich text box for the report, and unsupported html tags
are ignored.

I had assumed that Access' rich text fields would be more useful, and was
disappointed to discover these limitations after starting a project that
uses html for rich text.

"Ken Snell MVP" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> ACCESS 2003 and earlier versions do not have a rich text control/field, so
> they cannot store superscripts or subscripts. ACCESS 2007 does have a rich
> text control/field, so it will store them.
>
> Stephen Lebans has a rich text control for the earlier versions of ACCESS.
> See www.lebans.com website.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
> http://www.accessmvp.com/KDSnell/
>
>
> "dogleg left" <dogleg (E-Mail Removed)> wrote in message
> news:4E641ED1-0DC6-4C2F-A8F5-(E-Mail Removed)...
>>I would like to store information in Access - the data has subsripts and
>> superscripts that are meaningful. How do I enter these in access? Will
>> access
>> save them?


 
Reply With Quote
 
Ken Snell MVP
Guest
Posts: n/a
 
      10th Apr 2009
Thanks for the info about rich text in ACCESS 2007, Paul. I have not used
rich text there, so your information is very useful.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"Paul Shapiro" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Rich text fields in Access 2007 are severely limited. They support a
> minimal subset of html tags, mostly font and paragraph formatting. They do
> not support sub and superscripts. Worse than just not displaying the text
> correctly in a textbox with TextFormat set to Rich Text, Access sometimes
> silently removes the unsupported tags when you edit that data. I resorted
> to only allowing data edits with text boxes set to plain text format, so
> the user has to edit the tags manually. Displaying the data in a form
> works correctly in a web browser control, which supports all html tags,
> but that control does not have a CanGrow property so it's not of much use
> in reports. In that case I use a rich text box for the report, and
> unsupported html tags are ignored.



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subscripts and superscripts =?Utf-8?B?UldPbWRhbA==?= Microsoft Word Document Management 4 31st Oct 2008 03:04 PM
How can i use superscripts or subscripts in Access? =?Utf-8?B?bXRvY2hlcmk=?= Microsoft Access 1 16th Oct 2006 06:30 PM
Superscripts and Subscripts =?Utf-8?B?TEVX?= Microsoft Excel Misc 0 10th Nov 2005 03:06 PM
subscripts and superscripts Juggernnath Microsoft Excel Worksheet Functions 1 28th Sep 2003 06:52 AM
Re: Access subscripts/superscripts Arvin Meyer Microsoft Access 0 24th Aug 2003 11:53 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:27 AM.