can anyone tell me how to find out how many digits are in a number?
example if the number is 20 then the returned value is 2 if it's 123 then 3 and so on. what I need to do is add a number of 0s depending on how many numbers are available.
something like this.
value(number of digits in [string])
select case value
value = 000 & string
value = 00 & string
value = 0 & string
thanks for all suggestions.
You might want to look into display formats..
eg, if you have a field containing "1" and you need it to display "0001", put "0000" into the format property of whatever text box you're pumping the field into and it will add the zeros for you if necessary.