Clearing Feild?

[Wayne1158]

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.

[SlimJim]

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.

[Lee Smith]

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

[Wayne1158]

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

[tarheel]

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...

[Lee Smith]

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

[tarheel]

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

Bob...

[LaRetta]

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

[tarheel]

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

Thanks for the info.

Bob...