Erwin Craps
Erwin.Craps at ithelps.be
Wed Nov 26 11:17:08 CST 2003
Aha, that should be better. The > I never use because it is not hard coded in the field. I use an ucase in the Afterupdate event. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mitsules, Mark S. (Newport News) Sent: Wednesday, November 26, 2003 5:43 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Format of a field. Erwin, An input mask would accomplish this > Causes all characters that follow to be converted to uppercase. ! Causes the input mask to display from right to left, rather than from left to right. Characters typed into the mask always fill it from left to right. You can include the exclamation point anywhere in the input mask. a Letter or digit (entry optional). If you are dealing with only letters and numbers you could change it to: !>aaaa aaaa aaaa aaaa aaaa aaaa aaaa aaaa aa Mark -----Original Message----- From: Erwin Craps [mailto:Erwin.Craps at ithelps.be] Sent: Wednesday, November 26, 2003 11:23 AM To: accessd at databaseadvisors.com Subject: [AccessD] Format of a field. This is probably the first time in probably 10 years I'm looking at the field format in a table again. I never used them because of never needed or wanted it. I want to paper format an IBAN code which is 4 characters space 4 characters space 4 characters etc. something like this 1234 ABCD 5678 EFGH 90 The thing is that a IBAN code can be 34 character long wich means if all 34 characters are used you have at the end 2 characters. So I formated &&&& &&&& &&&& &&&& &&&& &&&& &&&& &&&& && But instead of aligning left it aligns right, so my code looks like 12 34AB CD56 78EF GH90 instead of 1234 ABCD 5678 EFGH 90 How can I resolve this that the code is left aligned and not right? I could write some code to do this, but this is like a real good situation where I could use the format property of a field/control. Erwin Craps Zaakvoerder www.ithelps.be/jonathan This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be <http://www.boxoffice.be/> * www.stadleuven.be <http://www.stadleuven.be/> IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: Info at ithelps.be Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: Staff at boxoffice.be <mailto:figures at boxoffice.be> _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com