[AccessD] Format of a field.

Hi Erwin

OK. A virtual handkerchief is attached!

/gustav


> Well I knew there where some formatting characters, no way I could find
> them in the Access Help. I've lost my patience with Access help since
> they putted it in HTML format.

> Thanks for the code again.

> Snifff, this makes me so happy :-)
> Lucky me, sniffff...
> No overtime today, straight to home....
> I'll tell my wife and kid that I'm early today thanks to you....


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Wednesday, November 26, 2003 5:38 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Format of a field.

> Hi Erwin

>> 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.
 
> You are close. This is how to format a textbox:

> !&&&& &&&& &&&& &&&& &&&& &&&& &&&& &&&& &&