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=12hqt0bnd/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124276538/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</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/
