I have a checkbox feild which I use to select records for printing. Once I have printed the records I need to find a way to clear the check box. I have read posts that Set Field[field;""] should do the trick. However the only way I can see of entering Feild;"" is through setting a calculation, but when I try this it asks for an operator. Any suggestions would be appreciated, this is probably a real simple one.

You need to use Replace Field Contents. You can set this up as a script attached to a button. If you want to ensure the checkbos is clear for the current found set only (presumably the records you are printing) then you don't need a script just attach the one operation to a button. If you want it to work across all records then you may need to script in a Show All Records first.

Hi Wayne, and Welcome to the Forum.

You can use a couple of different scripts. As Slim Jim suggested, you could use the Replace / Substitute Functions from the Menu or as a Script Step.

I like the Script approach if it is an on going need.

Try something like this:

Go to Layout [ original layout ]

Go to Record/Request/Page [ First ]

Loop

Thanks guys, after spending a whole day trying to figure this out you solved my problem in a few minutes, appreciate the help.

I was wondering, is this the method to use to clear fields when entering a data entry layout? When I enter mine there is always the last record entered showing but I want it to show blank fields.

Bob...

You could create a script that goes to a layout where you create your records, Find All Records, Create a New Record, Omit that new record, and then Find Omitted.

This will leave a blank new record for you to use. The Script steps would look something like this:

Go to layout (Record Creation)

Find All

New Record Requests

Omit

Show Omitted

Go to Field (Name of Field to go to)

HTH

Lee

Very interesting. Thanks for the info. I'll give that a go.

Bob...

Actually you don't need to do anything other than:

Go To Layout [ data entry layout ]

New Record/Request

You will then be on your new 'blank' record.

LaRetta

Great, I think I should have know that, Duh.

Thanks for the info.

Bob...