I have a VB6 form that is used for adding data, updating exisiting data, and viewing the data for a record. The problem is for the fields in these forms that either populate or let you type in currency values such as $4,443 from the database. When you click on the actual masked edit box regardless of whether it is editable or not, the value in the box changes to $0,000,004,443 and puts all the leading zeros in place. How can I remove these leading zeros so the value stays solid at 4,443 all teh time with no comma problems or anything, cause some values will come from teh database, and some values will be added.
Right now I have this line of code that populates the field
[url removed, login to view] = format$(GetFieldValue(g_rsGetSusp("FieldName")),m_kstrmoney)
and m_kstrMoney = $0,000,000,000
I tried all kinds of combnations of setting the mask on the maskedit edit box and changing this format properties m_strMoney variable to something else like #,###,##0.00 and things but nothign would work.
Could someone please offer me a solid fix for this so I know exactly how to format that value that comes in and so that when u click ont eh field the value doesnt add in leading zeros.
Also make sure you tell me what to put for the mask and the m_kstrmoney since if they arent matchign sometimes you get invalid property value error message
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Windows 2000 Server Visual Basic 6 SP3