Converting double to string

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
J

Jason Frazer

After i get done performing some calcutations i need to
save my answer in a string format.

This is the end of my code.

SRD = Round(SR, 1) 'Rounds SR to 1 decimal place
SRD4 = SRD * 10 'take out the decimal
[Sufficiency Rating] = SRD4 'Sets SRD4 to database field

For example, if SR = 78.9 then SRD4 = 789. How can I
convert to a string and make the string 4 charactres
long. Value returned shoult be "0789". The end result
must always be four characters long and use zero for
spaces. How can i do this and set it to my database field.
The database field size = 4 and data type = text.

Thanks for you time and help

Jason

Jason Frazer
 
Back
Top