Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
My If...then statement not cooperating
- Thread starter bren11
- Start date
thornmastr
Programmer
I have a calculated text box on a form. I want it to display 0.00 if the calculated amount is less than 0.00.
Wouldn't it be
If TextCalc.Value < 0.00 then
TextCalc = 0.00
Assuming your textbox is using a currency data type then,
if me.textcalc.value < 0 then
me.textcalc.value = 0
endif
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
Wouldn't it be
If TextCalc.Value < 0.00 then
TextCalc = 0.00
Assuming your textbox is using a currency data type then,
if me.textcalc.value < 0 then
me.textcalc.value = 0
endif
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
- Thread starter
- #3
Thanks for your reply...I had a syntax error that your suggestion pointed out to me...however, now when I run the calculation, it tells me the recordset is not updateable.
My form is based on a query with 3 tables, however the calculated field is only referenced later in an update query.
Can I make this be an editable field? Thanks for your syntax help, though....that was a big part of the problem..
- Status
Similar threads
