Solved

How to type a superscript into a text field

Posted on 2012-03-20
6
669 Views
Last Modified: 2012-03-24
Hello,

I've inherited an MS Access database the has superscripts in text fields.  There are no forms.  How can I put in more superscripts of letters other than the one in my sample?

I've tried cut and paste and keyboard shortcuts to no avail.  Please don't post the first results from a google search.

Database is attached.

Thanks
superscript.zip
0
Comment
Question by:eshurak
  • 3
  • 2
6 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 37745794
Access have no "insert symbol", you can do it manually. Almost any font have special symbols. You can insert them with Alt+symbol code in numeric keyboard. For example in Tahoma superscript 1 is Alt+0185, 2 is Alt+0178. You can open Word, select font, select symbol and under table you will see proper code.
http://office.microsoft.com/en-us/access-help/insert-ascii-or-unicode-latin-based-symbols-and-characters-HA010167539.aspx
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37748361
I'm with als315, the Alt codes may not be user friendly, but they do work...
;-)

Just curious?
Is the Superscript a deal breaker?
Is "5th" really that ugly...?
0
 
LVL 3

Author Comment

by:eshurak
ID: 37748618
I hear ya Jeff.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37749131
Just so we are clear,...
als315 has indeed  answered your question and you should accept that post.
;-)

For me, ...I just get "itchy" whenever someone wants to store "formatted" data in an Access database table.

Even with the new "Rich Text" (HTML) functionality, it is likely that a program you may need to output this data to may not recognize superscript (or any other formatted) text.

;-)

JeffCoachman
0
 
LVL 3

Author Comment

by:eshurak
ID: 37750000
It's a lookup for categories in a report.  The superscript text for footnotes that are needed for certain categories.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37750077
OK,

Makes sense...
;-)

Jeff
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question