Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is a example (thats close to working) of some code that I am using to
populate a field on an unbound form, The problem is that I need a comma in
the value of the Text_Offer1

Right now it is rounding but I actually need for it to round and add a comma.

Can anyone help?

Text117 = TEXTNAME & ", Please enter " & Round(Text_Offer1, 0) & " to
retrieve cost"
 
Try

Text117 = TEXTNAME & ", Please enter " & Format(Round(Text_Offer1,
0),"#,###") & " to retrieve cost"
 
Back
Top