[AccessD] formatting strings and placing them in a larger str ing

I think the mid$ does what I need.  I have to experiment.

JWC

-----Original Message-----
From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca]
Sent: Wednesday, August 11, 2004 2:40 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] formatting strings and placing them in a larger
string


Hi John:

Do you mean somthing like this:

strInitialString = right(string("@",intWidth) & strInitialString, intWidth)

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Colby, John
Sent: Wednesday, August 11, 2004 10:33 AM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] formatting strings and placing them in a larger
string


I need to take some piece of data, format it correctly (yyyymmdd for dates,
$$$$.CCCC  for currency, XXXX.DD for other floats, etc.

I then need to place it in a specific length field, padded left with spaces.

I then need to insert that string inside of a larger string at a specific
location.

Someone posted a solution for placing a string inside a larger string but I
can't find the email.

I can build up a string of @ characters into the correct length using a
simple:

    While Len(strPad) < mintLen
        strPad = strPad & "@"
    Wend

But is there any way to just specify that I want a string of 40 @
characters?

JWC
--
_______________________________________________
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