[AccessD] Format of a field.

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


More information about the AccessD mailing list