Can someone please help me with this. I am trying to format a single so that it is in the format of ##.00
My code gives me ##
No decimal point and no zeros to the right. If I use a string variable it works, but I need the field to not have a text qualifier eg. "".
Here is my code:
'omitted all other fields that are being written to text file.
strActual_Weight = (mrsSathExport!Actual_Weight) & ""
sngActual_Weight = Format(Val(strActual_Weight), "standard")
Write #1, strPO_Number, lngDate, strTrack_Number, strShipping_Cost, _
strShip_Method, sngActual_Weight, strPKGID