Hello all - new to this site and finding it a great source of info.

I cannot seem to figure out how to add a check box to my database where the default setting is "checked", and one would selectively uncheck the box on a record-by-record basis. Any suggestions would be appreciated.

In Define Fields you can setthe field to automatically fill with the text from your checkbox.

If the checkbox text is ACTIVE, go to Define Fields and select the field the checkbox is assigned to. Click on the Options button then the Auto-Enter tab. Click on the check box for Data and type ACTIVE in the box.

Click OK and you're done.

Hope this helps.

Steven B

Thanks for your response Steven, however... I cannot see how that will get my check box to always be automatically checked. (Maybe my level of understanding of FM is less than I thought.)

Hi MrPims,

in order to accomplish this job follow these steps:

• define a value list containing two values: X and blank

• switch to layout mode and right click on your checkbox field

• from the appearing pop up choose Field Formatting

• define this field as a check box and, from the appropriate pick list, select the value list you've just created

• confirm clicking on OK button.

• switch to browse mode

.... & have nice jobs.

[ June 04, 2001: Message edited by: JPaul ]