Deleting the contents in a text box (VBA Code)

[StevenSkinner]

Hello,

I need to Delete the contents in a text box which is linked to a table.

but when I write the below code

me.textbox.value = ""

it says that you can not input a null value. what should I do ?????

(The table field is set to Not required and i've input a validation rule of 'is Null')


it's like I need to Delete the contents - but how do you do this with VBA ???

 

[SydneyGeek]

Try [MyTextBox] = Null. You may need to remove the validation.

Denis

 

[StevenSkinner]

You may be a geek but I Love you !!

Thanks alot that worked just fine - Top Man !