have 3 display as 03 in table from form

Hello I have this code:
StrCvsN = IIf([chk1] = -1 Or [chk2] = -1, 3, IIf([chk3] = -1 Or [chk4] = -1, 24, 0))

I cannot change to IIf([chk1] = -1 Or [chk2] = -1, 03,IIf
i am attaching database - the code is behind form- is there a way to display 3 as 03?
thank you
data.mdb
davetoughAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
use
  "03"  

or Format(3,"00")
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
How about:
StrCvsN = Format(IIf([chk1] = -1 Or [chk2] = -1, 3, IIf([chk3] = -1 Or [chk4] = -1, 24, 0)),"00)

mx
0
 
GRayLCommented:
The short answer is NO if you want the result to be cast as a number.  In the two previous answers, the result is cast as a string.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I was going by 'display'
display 3 as 03

mx
0
 
davetoughAuthor Commented:
thanks- i should of said string- but that is what i need
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.