Darren D
darren at activebilling.com.au
Mon Feb 18 17:46:39 CST 2008
Hi Arthur I do recall that being the case - but I am in the habit now of doing it in say... the after update of the field using the built in UCASE() function Not sure what version UCASE() became a std function in though - check your version has it EG SomeField_AfterUpdate() Me.SomeField = Ucase(SomeField) End sub I find working with masks is a real PITA sometimes Darren ----------------- T: 1300 301 731 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Tuesday, 19 February 2008 12:57 AM To: Access Developers discussion and problem solving Subject: [AccessD] Upper Case Input Mask To force upper case in a given field, Is it enough just to put ">" at the beginning of the mask, or do you have to supply a marker for each place in the string? TIA, Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.5 - Release Date: 14/02/2008 12:00 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.5 - Release Date: 14/02/2008 12:00 AM