Does anybody know of a calc for conditional formatting that is based on whether the record has been committed.

I have not been able to find an answer to this with a bit of web searching.

many thanks in advance.

Mike

On the layout setup, you can run a script using the OnRecordCommit under the script triggers tab.

However, if you are using a commit button for your users, you can create a commit field and have your button set it to "1" or whatever to show that that record/button was used when creating the record, this is not really needed as FM saves as you go. unless you have unchecked save record changes automatically, it is hard to help you without more information or a sample DB.

More information on what you are trying to do may be helpful, their are probably many ways to accomplish what you are looking form.

a calc for conditional formatting that is based on whether the record has been committed

Such calculation is easy to construct using the Get ( RecordOpenState ) function. Whether this would work for conditional formatting is another question - a question of getting the object to redraw when the record is opened.