Conditional formatting and the Go to Field script step

April 14, 201015 yr

If this is in the wrong forum, please feel free to move it.

I came across something odd today in a FileMaker database, and I was able to recreate it in the attached file.

I had a button that runs script on a related field on a layout. The script did a few checks, and then if they all passed, it had a Go to Field[Field] script step.

This field was layered on top of another field that had conditional formatting applied to it. basically the formatting would color a section behind a few fields if certain criteria were met. The formatting field was a different one than the target of my Go to Fielfd[].

Every time I would run that script, it would go to the formatting field in the background.

What I think I narrowed it down to was that the conditional formatting rules that were applied to the formatting field included checking the field that I wanted to eventually go to.

In the example file attached there are two layout, one called "Go_To_Field_Test with formatting" and one called "Go_To_Field_Test No formatting". The only difference between the two layouts is that on the no formatting one.

On Go_To_Field_Test with formatting when you click "Go To Test2", to the larger field layered behind it.

On Go_To_Field_Test No formatting it correctly puts the focus in Test2

Is this a known issue, and if so, what - if any - are the workarounds for it?

I have noticed that this behavior is the case in FM 9 - FM 11.

Thanks

~Mark

Go_To_Field_Test.fp7.zip