I am using the data control to extract data off an Access database. I am
using the MaskEditBox to read in some of the numeric fields so that I can
format the numbers in a consistant way. Unfortunately, I cannot see how to
get the MaskEditBox to right-justify the data within the control. It always
left-justifies it.

I tried using a label box, then setting up code within the Change event like
this:

lblTest.Caption = Format(lblTest.Caption, "#,##0")

This works, but when you switch to a new record, the formated version of the
data gets written to the field in the record. I would like to keep the
underlying value as-is (it has decimal places).

Does anyone have a solution to this formating problem?