[AccessD] How to right justify numeric fields and pad with spaces on the left.

Charlotte Foust charlotte.foust at gmail.com
Mon Jun 6 19:00:34 CDT 2011


Isn't this reinventing the wheel?  An export spec should accomplish the same
thing without having to process each value inidividually.

Charlotte Foust

On Mon, Jun 6, 2011 at 4:52 PM, Debbie <delam at zyterra.com> wrote:

> When I needed to do this, I made a function that i passed the string and
> the number of total chars needed. It would loop through until the length was
> the number of chars and would add a space ( or in my case a 0) to the
> beginning of the string.
>
> Debbie
>
> Sent from my iPhone
>
> On Jun 6, 2011, at 4:12 PM, "Brad Marks" <BradM at blackforestltd.com> wrote:
>
>  We are using Access 2007 to create an output file for another firm.
>>
>> The specs for this file are dictated by the other firm.
>>
>> The specs call for numeric fields to be right justified and padded with
>> spaces on the left.
>>
>> What is the best way to do this with Access 2007?
>>
>> Thanks,
>> Brad
>>
>> --
>> 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