Unbound text box calculation
in [Form]
|
Prev: Remove CAPS
Next: Populate Textbox
From: dab1477 on 2 Jun 2010 19:16 Tom, To answer you questons: * What is in the ControlSource of this box3? ....as noted in my original post the ControlSource was formula"=text box A input / text box B input". * What if any VBA code is in this form that may be related? ....there was code. I omitted the formula from the control source and all seems to be working now. Thanks. * Any macros operating on this box3? .....no macros in box C. I resolved the issue by binding Box C to my table. Although a calculation and this would not require binding, I found that it may be useful. Binding the text box to the table resolved my issues. Thanks. "Tom van Stiphout" wrote: > On Wed, 2 Jun 2010 06:17:01 -0700, dab1477 > <dab1477(a)discussions.microsoft.com> wrote: > > That is not the way an unbound textbox normally behaves. So I have > these questions: > * What is in the ControlSource of this box3? > * What if any VBA code is in this form that may be related? > * Any macros operating on this box3? > > -Tom. > Microsoft Access MVP > > > >Thanks in advance for the assist. My mind went numb... > > > >What must I do to have an unbound field only perform the calculation for the > >current open record that I am working in and not show data in a new records > >same unbound field when I go to the next record entry? > > > >I have an unbound text box on a form - call it Box C. In it's properties > >control source I have a calculation (i.e. =text box A input / text box B > >input) that I wish to show within the form prior to moving to the next > >record. I then wish this field to recalculate or return null (if box A and/or > >B are empty). Box C will calculate correctly, but when I move to the next > >record to input data, Box C maintains the previous record's data - but only > >within Box C. All other fields are blank and ready to accept new data. > >Box C calculates within the new record based upon the prior records data in > >Box A and Box B; even when I have not entered any data into the new record. > >Please point me in the right direction. Thanks > . >
From: Tom van Stiphout on 3 Jun 2010 00:01
On Wed, 2 Jun 2010 16:16:01 -0700, dab1477 <dab1477(a)discussions.microsoft.com> wrote: > * What is in the ControlSource of this box3? >...as noted in my original post the ControlSource was formula"=text box A >input / text box B input". The reason I asked is that there often is a syntax error in an expression that we can spot if we get the real expression rather than your stylized version. Glad you got it to work. -Tom. Microsoft Access MVP >Tom, >To answer you questons: > * What is in the ControlSource of this box3? >...as noted in my original post the ControlSource was formula"=text box A >input / text box B input". >* What if any VBA code is in this form that may be related? >...there was code. I omitted the formula from the control source and all >seems to be working now. Thanks. >* Any macros operating on this box3? >....no macros in box C. >I resolved the issue by binding Box C to my table. Although a calculation >and this would not require binding, I found that it may be useful. Binding >the text box to the table resolved my issues. Thanks. > >"Tom van Stiphout" wrote: > >> On Wed, 2 Jun 2010 06:17:01 -0700, dab1477 >> <dab1477(a)discussions.microsoft.com> wrote: >> >> That is not the way an unbound textbox normally behaves. So I have >> these questions: >> * What is in the ControlSource of this box3? >> * What if any VBA code is in this form that may be related? >> * Any macros operating on this box3? >> >> -Tom. >> Microsoft Access MVP >> >> >> >Thanks in advance for the assist. My mind went numb... >> > >> >What must I do to have an unbound field only perform the calculation for the >> >current open record that I am working in and not show data in a new records >> >same unbound field when I go to the next record entry? >> > >> >I have an unbound text box on a form - call it Box C. In it's properties >> >control source I have a calculation (i.e. =text box A input / text box B >> >input) that I wish to show within the form prior to moving to the next >> >record. I then wish this field to recalculate or return null (if box A and/or >> >B are empty). Box C will calculate correctly, but when I move to the next >> >record to input data, Box C maintains the previous record's data - but only >> >within Box C. All other fields are blank and ready to accept new data. >> >Box C calculates within the new record based upon the prior records data in >> >Box A and Box B; even when I have not entered any data into the new record. >> >Please point me in the right direction. Thanks >> . >> |