Input Mask >

  • Thread starter Thread starter kirstie adam
  • Start date Start date
K

kirstie adam

Hi all,

I have a text field in my table which i want to show in uppercase.

I have done this before, but can't remember how.

At the moment i have put > in the input mask section - but when i do that it
won't even let me type in the field at all.

Any suggestions?

Thanks,

Kirstie
 
Kirstie

I can't tell if you are trying to display the contents of the field as
uppercase (use UCase() in your query), or if you are trying to store only
UPPERCASE in your table/field (reconsider this).

If the latter, be aware that you won't be able to (easily) convert all
uppercase into something humans would prefer to see/read. But if you store
normal (mixed), you can always use UCase() and LCase() to modify the display
of that data.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
I am a novice with Access and am trying to import text data and convert two
fields uppercase. I have read other questions similiar to mine but have not
discovered an answer so maybe there is no way to accomplish what I am trying
to do. Once the data has been imported I use a print utility that will print
my information in the formats I need. I have used an input mask but that
only displays the field in uppercase and I need that data converted.
I am not sure what you are talking about regarding Ucase() and Lcase(). I
am not a programmer so that may be the reason. :-(
Is this possible? Any help or comments would be greatly appreciated.

Thank you. Have a good day.

Don C.
 
On Tue, 26 Dec 2006 21:07:01 -0800, Don Coleman <Don
I am a novice with Access and am trying to import text data and convert two
fields uppercase. I have read other questions similiar to mine but have not
discovered an answer so maybe there is no way to accomplish what I am trying
to do. Once the data has been imported I use a print utility that will print
my information in the formats I need. I have used an input mask but that
only displays the field in uppercase and I need that data converted.
I am not sure what you are talking about regarding Ucase() and Lcase(). I
am not a programmer so that may be the reason. :-(
Is this possible? Any help or comments would be greatly appreciated.
Click to expand...

Back up your .mdb file, just in case. Update queries aren't
reversible!

Create a Query based on your table.

Select the field you want upper-cased - I don't know the fieldname so
let's say the field is named MyField.

Change the query to an Update query using the Query menu option, or
the query-type tool in the toolbar.

On the Update To line under MyField type

UCase([MyField])

The square brackets are essential (otherwise it will replace all
records with the word MYFIELD in caps). Use your own fieldname of
course, rather than MyField.

Run the query by clicking the ! icon.

John W. Vinson[MVP]
 
Back
Top