Hello,
I have several fields on a form. Some fields are general numbers, some are currency. The data in the general number fields line up right justified as do the currency fields. The currency fields, however, do not line up ALL THE WAY to the right. My client thinks it looks "funny" and the client is always right. I can create an unbound field and set the
Control Source of the unbound field to the code below: Format([CurrencyField],"$#,###") and right justify the text. This works fine for those fields that are locked and will not be edited. But what about the currency fields that will be edited. I can't set the control source like described above and edit. Any ideas?
Thanks!
I have several fields on a form. Some fields are general numbers, some are currency. The data in the general number fields line up right justified as do the currency fields. The currency fields, however, do not line up ALL THE WAY to the right. My client thinks it looks "funny" and the client is always right. I can create an unbound field and set the
Control Source of the unbound field to the code below: Format([CurrencyField],"$#,###") and right justify the text. This works fine for those fields that are locked and will not be edited. But what about the currency fields that will be edited. I can't set the control source like described above and edit. Any ideas?
Thanks!
