Hi Tom,
There are lots of different ways to approach this... and these are just a
few that I can think of right of the top of my head.
Without changing existing data, just changing how it is *displayed*...
(This would require doing this for all forms / reports)
----------------------------------------------------------------------
Format: "<" ... in each of the textual control's property sheets
----------------------------------------------------------------------
Or *changing the existing data permanently*.(Backup your database first!)
Design an Update Query that would change the case of the data in each field,
again using the StrConv() function.
(BTW, The Constant for "vbLowerCase" = '2', and you'll have to use it that
way in a query.)
eg.
UPDATE tblArtists SET tblArtists.ArtistName = StrConv([ArtistName],2),
tblArtists.Genre = StrConv([Genre],2);
----------------------------------------------------------------------
Later, If you wanted to ensure that data will contnue to be entered in the
correct format, you could use the StrConv() function in the AfterUpdate
event of each textbox control.
--
HTH,
Don
=============================
E-Mail (if you must)
My*****@Telus.net
Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)
I'm an Access97 user, so all posted code
samples are also Access97- based
unless otherwise noted.
Do Until SinksIn = True
File/Save, <slam fingers in desk drawer>
Loop
================================
"Tom" <to*@rickwhite.co.uk> wrote in message
news:ce**************************@posting.google.c om...
I have data entered in Uppercase. I need to view it in lower case in a
continuous form. Any ideas???