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

I normally use:

Right$(Space$(x) & str$(myNumber),x)

but you can also use

myString = space$(x)
rset mystring =  str$(myNumber)

Note that str$() is not strictly necessary because VBA will implcitly convert myNumber to a 
String, but I prefer to do it explicitly.


-- 
Stuart

On 6 Jun 2011 at 16:12, Brad Marks 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
>