Comparing Original Value to New Value in the same textbox.

[ApexData]

I have a bound textbox called txtMyBox with the current string value
of "200".
Once the user enters the textbox, and while the user is still in the
textbox, I would like to check the changed value using a function to
see if this changed value exists in a table. If it does, I want do
give a Msgbox Warning and restore the original value.

I thought that I would require the OnUpdate property of the textbox to
do this, but I can't seem t
to compare the original value to a newly entered value. Am I in the
wrong property???

Thanks Greg

[ApexData]

Sorry

Meant to say BeforeUpdate property!

>thought that I would require the OnUpdate property of the textbox

to

>do this, but I can't seem t
to compare the original value to a newly entered value. Am I in the
wrong property???

Greg

[ApexData]

My Solution required the AfterUpdate Event

Had to assigned value to a Public Variable outside the AfterUpdate
event
strPubVar = Nz(Me.txtMyBox, "")

Then in the AfterUpdate Event of txtMyBox placed my duplicate
function:
If Duplicate Then
Me.txtMyBox = IIf(Len(strPubV ar) = 0, Null, strPubVar)
End If

[John Mishefske]

Ap******@gmail. com wrote:

I have a bound textbox called txtMyBox with the current string value
of "200".
Once the user enters the textbox, and while the user is still in the
textbox, I would like to check the changed value using a function to
see if this changed value exists in a table. If it does, I want do
give a Msgbox Warning and restore the original value.

I thought that I would require the OnUpdate property of the textbox to
do this, but I can't seem t
to compare the original value to a newly entered value. Am I in the
wrong property???

I believe the .OldValue property of the textbox will hold the original value and the
..Value property will hold the updated value. The .Text property may also be of interest.

..BeforeUpdate would seem to be the event to use. Haven't tested this but should be easy
enough for you to experiment with.

--
'---------------
'John Mishefske
'---------------

[ApexData]

John

I am using Access2K, and do not see the .OldValue property of the
textbox.
This must have been a latter improvement?

Thanks Greg

[Rick Brandt]

<Ap******@gmail .comwrote in message
news:11******** **************@ v45g2000cwv.goo glegroups.com.. .

John

I am using Access2K, and do not see the .OldValue property of the
textbox.
This must have been a latter improvement?

There is no property box for it as it is only available in code. All versions
have it.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com