I have a simple Excel database containing 12 columns and about 3000
records.
One of the columns represents a simple Price field in which the
numbers are formatted for 2 decimal places using the format
"#,##0.00". (This is not a calculated field.)
I have created a UserForm containing text fields to match the fields
in the database, and when I initiate the 1-line code "UserForm1.Show",
the UserForm appears on screen with the text fields reflecting the
information from whatever record the cellpointer is on when I initiate
that 1-line macro.
It works perfectly except for the format of the text field
representing the Price field. If the last digit of the number in the
Price field ends in a zero (for example 79.50), the text field in the
UserForm drops that zero and displays 79.5.
Is there any way to have that UserForm text field formatted as
"#,##0.00" so that it will show 79.50 rather than 79.5?