Trevor
02-11-2008, 12:17 PM
Has anyone experienced on a subform a curency field set to 2 decimal places truncate ie if the value is $1.00 the field when clicked on will show $1 or if the value is $1.10 when the field is clicked on it will display $1.1
but if the value is $1.01 the field when clicked on appear fine.
This occurs in my [total] field and its format is set to currency w/2 decimal places. I have tried writeing code in the main form to formate but doesn't work, well the code apear to be vaid but the text box won't use it, i have placed it on current, the code I tried is[Subform]forms![textbox] = right (textbox, 2) & _ Format(Right(Textbox, 2), "00")
and this seems to be effecting my call to the[textbox] on the sub to display it on my main form, even after I click off [texbox] on the subform so that the vale is ie $0.00 it still trucates the value on the main form so if it was 0.00 the main form will show $0 or if the value was $1.10 the main form would then show $1.1 but if the value were $1.01 it would be fine on the main form aside from this esstetic problem it works and the main form text box is set to currency decimal places =2.
Does anyone know of a work around for, this ?, and both textboxes are unbound
but if the value is $1.01 the field when clicked on appear fine.
This occurs in my [total] field and its format is set to currency w/2 decimal places. I have tried writeing code in the main form to formate but doesn't work, well the code apear to be vaid but the text box won't use it, i have placed it on current, the code I tried is[Subform]forms![textbox] = right (textbox, 2) & _ Format(Right(Textbox, 2), "00")
and this seems to be effecting my call to the[textbox] on the sub to display it on my main form, even after I click off [texbox] on the subform so that the vale is ie $0.00 it still trucates the value on the main form so if it was 0.00 the main form will show $0 or if the value was $1.10 the main form would then show $1.1 but if the value were $1.01 it would be fine on the main form aside from this esstetic problem it works and the main form text box is set to currency decimal places =2.
Does anyone know of a work around for, this ?, and both textboxes are unbound