Display Long as text in report!?

  • Thread starter Thread starter Niklas Östergren
  • Start date Start date
N

Niklas Östergren

Hi!

Is it possible to convert a parameter from long to text by adding zero´s in
front of the long data if the value is less than 8 digits?

Ex.

Lets say that I store a valur as data type long (100010). When I want to
print this, either in a report or export it to a textfile or something I
like to add 2 digits so I present 00100010 instead.

TIA!
// Niklas
 
OK!

Thank´s a lot!

// Niklas


Cheryl Fischer said:
Sure ...

Format([MyLongVal], "00000000")


hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Niklas Östergren said:
Hi!

Is it possible to convert a parameter from long to text by adding zero´s in
front of the long data if the value is less than 8 digits?

Ex.

Lets say that I store a valur as data type long (100010). When I want to
print this, either in a report or export it to a textfile or something I
like to add 2 digits so I present 00100010 instead.

TIA!
// Niklas
Click to expand...
Click to expand...
 
Back
Top