how to use MaskEdBox to format 2 char currency symbol ?

Posted on 2000-05-08
Last Modified: 2012-05-04
I'm a programmer from Malaysia, and our currency symbo is "RM" with are 2 characters, how can I set this format in the MaskEdBox to auto format the numeric data ?
Question by:eugeneng

Expert Comment

ID: 2790960
Where do you want to display RM? Can you please tell this clearly?

Expert Comment

ID: 2791082
please explain ur problem clearly


Expert Comment

ID: 2791099
Set the mask property of maskedit control to get the required format.

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.


Author Comment

ID: 2792228
I'm sorry about the my ambiguous question. Ok now, I placed a maskedit on my form and set the  "Mask" property to "RM #,###,###.##", and then I key in 1234 into the maskedit. When this maskedit lost the focus, the content of the maskedit become "RM 1,234,.". And if I erase the "Mark" property and set the "Format" to "RM #,###,###.00", if I key in "1234" again, when the maskedit lost the focus, the content get formated to "R5,#,###,###.00". How do I get "RM 1,234.00" when the maskedit lost the focus.

Accepted Solution

manchula earned 50 total points
ID: 2792251
Try giving the same format R5,#,###,###.00 to both the Mask & Format Properties

Author Comment

ID: 2812692
manchula's method works, how do I give this the point ?

Author Comment

ID: 2812694
thanx man..

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DIR issue 7 53
passing a value with stream reader AFTER a ";" 3 66
Copy a row 12 61
IF ELSE Statement in Excel Macro VBA 16 62
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now