2. ASPRunnerPro General questions
  3. Numeric field fixed format
This topic is locked

Numeric field fixed format

 		12/22/2008 5:23:53 AM
ASPRunnerPro General questions
I
 Inter1908 author

Hi all,
I have a numeric field (autoincrement), in ms access I can fix the format to appear as 000123 or 000123-08 instead of 123.

is it possible to do it with ASPRunner pro 6?

if so how can I set it in list and print page.
Thanks
my best regards,

Tarek

ASPRunner pro 6 build 672
J
 		Jane 12/22/2008

Hi,
use custom format on the "View as" settings dialog on the Visual Editortab.

Here is just a sample:

if strValue<10 then

strValue = "00000" & strValue

end if

if strValue<100 then

strValue = "0000" & strValue

end if

if strValue<1000 then

strValue = "000" & strValue

end if
I
 		Inter1908 author 12/23/2008

Hi,

use custom format on the "View as" settings dialog on the Visual Editortab.

Here is just a sample:


Thanks Jane works great <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=36212&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />
L
 		lanochka 12/31/2008



Thanks Jane works great <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=36382&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />