var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Format / Validation / Input Mask
I am trying to create a text box that stores a negative dollar amount without having to manually key the minus sign.
I have tried input masks, formats, and validations, but cannot get the value to store as negative, without manually entering it as such.
I am using Access 2000 for my front end and SQL Server 2000 as the backend. The datatype is smallmoney.
Any help is appreciated.
A debit or credit can be either positive or negative...such that you can have a negative credit....you'll have to worry about a sign, I' afraid...
If you are using Access, see if this will work:
Add you textbox control to the form, but make it invisible.
Add another (visible) textbox to the form and set its value to the value of your field time -1. Enter you data in this field.
If you field's don't update automatically, you may need to put an AfterUpdate event on your unbound control that sets the value of the hidden field.
If setting the value of the unbound field to the negative of the bound field doesn't work, you could also put an OnCurrent event in your form that sets the value of the unbound field.
You'll need to work out the details, but you see the idea is to hide the actual field and switch the sign with code when the value is updated.