TextBoxes Dirty?

[k209310]

Hi

is there a way of determining whether or not a textboxes value has been changed. I am aware of the dirty property but this only determines weather or not a form has been changd - i needed to know weather a specifi text box has been changed

Any advice is greatly recieved

Chris

 

[Rich]

The BeforeUpdate event of the control will do it

 

[k209310]

Thanks for the reply rich

I was aware of the event i need something to put in an if statement if possible. Eg

If the textbox has been changed then

is this possible?

Cheers

Chris

 

[Mile-O]

If it's one specific textbox then why not create a form level variable and store the textbox's value in that when the form loads.

On the BeforeUpdate you can evaluate whether the new value with that which was stored in the variable.

 

[Rich]

I actually prefer to use a function and then just Call it, but you can use
If Not Me.NewRecord Then
do whatever

 

[k209310]

Thnaks for the replies. I think my best best bet was to load the values in to a variable and check them from there.

Thanks for the help

Chris