Clearing contents of a field when form opens (1 Viewer)

[Rob Ross]

I have a database that tracks help desk tickets. The table that carries the data has a corrective action field which when updated added the new comments to a History field that shows all comments with a date stamp. The form that opens the record for editing opens with all fields prefilled as to what was in them when the ticket was saved. Is there a way to clear one of the fields when the form opens or better yet, clear it when the field is tabbed into or clicked in?:banghead:

 

[John Big Booty]

Me.FieldName =""

Will clear a named field, is that what you are after

 

[Rob Ross]

I tried that but get an error saying I can't assign a value to that field.

 

[dstone10]

What about on Form_Load

controlname.Value = ""

(Basically leave out the Me. and add a .Value at the end instead)

On my login screen i use

txtUsername.Value = ""
txtPassword.Value = ""