Clear an unbound field on a form

[kmsperry]

Is there a way to clear an unbound field on a form from a macro? My form takes input from unbound fields and appends that data to a table. I want to clear those fields and requery the DB after the append from a button. Is there a way to do this without VB code (I'm not great at VB)?

Thanks,

KMS

 

[pbaldy]

In a macro you'd use the SetValue action, setting it to 0, "" or Null as appropriate to your needs.

 

[kmsperry]

Paul,

I have Access 2007 and the setValue action does not show up in the list of actions I have. I looked elsewhere and found someone commenting as follows:

Sorry for the delayed reply. Infact MSAccess 2007 doesn't support setvalue anymore because of the new RIBBON technology.
If your running a Access 2003 application in Access 2007 this function doesn't function on menu's. Which is why its still present for backward compatibility on other calculative functions.

I looked around and can't figure out how to access it since it doesn't show up. It sounds exactly what I'm looking for however.

KMS

 

[spikepl]

Click on Show all Actions icon in the macro

 

[pbaldy]

Spike has supplied your solution (that will be an option on the ribbon when the macro is in design view). Whoever wrote that quote doesn't know what they're talking about.

 

[kmsperry]

Thank you, that is what I needed.

KMS