<div>
You can use the Space() function instead of Pad<br />
<br />
mx
</div>


You can use the Space() function instead of Pad

mx

<div>
SELECT Right(&quot; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&quot; &amp;&nbsp;nbr, 10) AS PaddedNbr<br />
FROM SomeTable
</div>


SELECT Right("          " & nbr, 10) AS PaddedNbr
FROM SomeTable

<div>
SELECT Format([YourNumber],&quot;00000<wbr />00000&quot;) AS NewNbr FROM [YourTable];<br />

</div>


SELECT Format([YourNumber],"0000000000") AS NewNbr FROM [YourTable];


<div>
<div class="content wysiwyg-content">
How do I pad left to a field I select so it is always 10 characters long (padded with spaces. So this:<br />
<br />
2834<br />
02149803<br />
203985<br />
234<br />
<br />
Would become this in my SELECT statment:<br />
&nbsp; &nbsp; &nbsp; 2834 (padded 6 spaces to the left of the number)<br />
&nbsp; 02149803 (padded 2 spaces to the left of the number)<br />
&nbsp; &nbsp; 203985 (padded 4 spaces to the left of the number)<br />
&nbsp; &nbsp; &nbsp; &nbsp;234 (padded 7 spaces to the left of the number)<br />
<br />
I'm looking for something in MS Access where I can do something like SELECT PAD(nbr,&quot; &quot;) FROM table. Anything like this exist?
</div>
</div>


How do I pad left to a field I select so it is always 10 characters long (padded with spaces. So this:

2834
02149803
203985
234

Would become this in my SELECT statment:
      2834 (padded 6 spaces to the left of the number)
  02149803 (padded 2 spaces to the left of the number)
    203985 (padded 4 spaces to the left of the number)
       234 (padded 7 spaces to the left of the number)

I'm looking for something in MS Access where I can do something like SELECT PAD(nbr," ") FROM table. Anything like this exist?

How do I pad spaces to a SELECT field in MS Access?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.