Deleting info in a text boxes (An easy one) (1 Viewer)

[Wee]

I'm sure this is an easy problem to solve but at this time in the morning I am struggling.

I am looking to have a command button that On Click deletes the info in 3 text boxes.

Any help greatly received,

Wee

 

[maxmangion]

on the OnClick event you can put

Me.Textbox1 = ""
Me.Textbox2 = ""
Me.Textbox3 = ""

 

[Wee]

Thanks, next problem:

Run-time error '3315'

Field 'Hazardous Substances.R/S Phrases' can't be a zero length string.

So how do I change the field so that it can? My lack of access knowledge is really showing today, but on the plus side my new avator works

 

[maxmangion]

check in your table properties if you set the options Required and Allow Zero length, they should be No and Yes respectively

 

[Mile-O]

Me.Textbox1 = ""
Me.Textbox2 = ""
Me.Textbox3 = ""

Me.Textbox1 = Null
Me.Textbox2 = Null
Me.Textbox3 = Null

 

[Wee]

That was pretty simple

Thank you very much, I could have been staring at that for hours

 

[Wee]

I'm not changing it now Mile-o-Phile

I have loads more bigger problems to come as the day progresses which you can help with though, unless I get sidetracked by the olympics, shhh don't tell my boss

 

[Mile-O]

I'm not changing it now Mile-o-Phile

unless I get sidetracked by the olympics

It's interesting that with reference to the Olympics, you shouldn't be concerned about your own performance.

 

[Wee]

Well I'm pretty sure i could win the gold in the lazyest employee event. Apparently they're not adding that until Beijing though so I'll have to keep up this rigerous training regime for the next 4 years