if less then 7 digits (1 Viewer)

[stu_c]

Hi all
I have reference numbers such as 12345/89 iI want an if query to say if <7 then put leading zeros etc

eg: 123/89 changes to 00123/89 or 23/56 to 00023/56

 

[arnelgp]

Expr1: String(7-Len(Number),"0") & Number

 

[Minty]

Is this for display purposes only?
If it is you can format the control on a form to display leading zero's.

 

[The_Doc_Man]

Minty, would that format string work for text? Because his numbers include a virgule (/) in his examples.

 

[Minty]

Good spot @The_Doc_Man .
I think you may need to use something like

000000\/00