[AccessD] Format of a field.

Mitsules, Mark S. (Newport News) Mark.Mitsules at ngc.com
Wed Nov 26 10:43:06 CST 2003


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


More information about the AccessD mailing list