<div>
because it is not numeric...
</div>


<div>
try<br />
&quot;00000000\.00\.00\.00\.00#<wbr />&quot;<br />
or<br />
&quot;00000000\.00\.00\.00\.00_<wbr />&quot;<br />
<br />
trying to remember
</div>


try
"00000000\.00\.00\.00\.00#"
or
"00000000\.00\.00\.00\.00_"

trying to remember

<div>
you can use something like this (not tested)<br />
<br />
Mid(ChargeNumber,1,8) &amp;&nbsp;&quot;.&quot; &amp;&nbsp;<br />
Mid(ChargeNumber,9,2) &amp;&nbsp;&quot;.&quot; &amp;&nbsp;<br />
Mid(ChargeNumber,11,2) &amp;&nbsp;&quot;.&quot; &amp;&nbsp;<br />
Mid(ChargeNumber,13,3)
</div>


you can use something like this (not tested)

Mid(ChargeNumber,1,8) & "." & 
Mid(ChargeNumber,9,2) & "." & 
Mid(ChargeNumber,11,2) & "." & 
Mid(ChargeNumber,13,3)

<div>
ah yes the @ good catch HainKurt
</div>


<div>
Thanks. &nbsp;That's what I was looking for. &nbsp;I had checked help in Access 97 but I saw no mention of using @.
</div>


Thanks.  That's what I was looking for.  I had checked help in Access 97 but I saw no mention of using @.

<div>
for more info on formatting strings, refer to<br />
<br />
<a href="http://office.microsoft.com/en-us/access-help/format-property-text-and-memo-data-types-HA001232747.aspx?CTT=5&origin=HA001228839" rel="ugc">http://office.microsoft.com/en-us/access-help/format-property-text-and-memo-data-types-HA001232747.aspx?CTT=5&origin=HA001228839</a>
</div>


for more info on formatting strings, refer to

http://office.microsoft.com/en-us/access-help/format-property-text-and-memo-data-types-HA001232747.aspx?CTT=5&origin=HA001228839 [http://office.microsoft.com/en-us/access-help/format-property-text-and-memo-data-types-HA001232747.aspx?CTT=5&origin=HA001228839]

<div>
<div class="content wysiwyg-content">
I am trying to format the following strings using the format function Format( Cstr(Format([ChargeNumber]<wbr />)),&quot;000000<wbr />00\.00\.00<wbr />\.00\.000&quot;<wbr />) <br />
<br />
Input String &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Desired Output &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Actual Output<br />
18006350037100000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18006350.03.71.00.000 &nbsp; &nbsp;18006350.03.71.00.000<br />
1800565125710032A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18005651.25.71.00.32A &nbsp; &nbsp;1800565125710032A<br />
<br />
As you can see, the first input string is formatted properly, however the second string is not being formatted.<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />

</div>
</div>


I am trying to format the following strings using the format function Format( Cstr(Format([ChargeNumber])),"00000000\.00\.00\.00\.000") 

Input String                                  Desired Output                 Actual Output
18006350037100000              18006350.03.71.00.000    18006350.03.71.00.000
1800565125710032A              18005651.25.71.00.32A    1800565125710032A

As you can see, the first input string is formatted properly, however the second string is not being formatted.
          


Problem formatting a string

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.