Hi Owen, I just tried it and it works a treat! Cheers for that!!! Rgds Lewis
owen_group_profile <[EMAIL PROTECTED]> wrote: 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 LINKS Visit your group "AccessVBACentral" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hp390g9/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124320806/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</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/
