lol - Hi Lewis,
ignore that previous mail. Go to the design view of the table, and in the format of the address field just insert the 'greater than' symbol (>). :) Owen --- In [email protected], "owen_group_profile" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm not sure if you can apply that as a default, but if data entry is > done via a form, then you make the on_exit() event for the address > field read like: > > > me.addressTextBox = UCase(me.addressTextBox.text) > > Alternatively, you could let the data entry be random, and then tun a > quick update query on the table before you need to check / display it: > > Docmd.RunSQL "UPDATE MyTable SET MyTable.address = UCase([address]);" > > > Hth, > > Owen > > > > > --- In [email protected], "lewiskidd" <[EMAIL PROTECTED]> > wrote: > > Hi All, > > > > Wondering if some kind group member can help me with a problem that I > > have. I would like to install a default value for a field in access > > that will make all entries into the address field uppercase. > > > > Rgds > > > > > > > > Lewis ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hkn3jn8/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124276982/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
