Ole - Applying focused field modification

Report · Jun 21, 2016

Hi,

I'm trying to get fields values from a form with Vba.

When a user enter text or select an item and leave the focus in the field, the value is not set.

I resolved this by applying ClearSelection before reading.

It works well for all types of field except listbox.

I also tried:

oForm.Fields.ExecuteThisJavascript "this.applyRedactions()"

But it doesn't apply modification for any type of field.

Is there a better method for aplying focused field modification before reading ?

Report · Jun 21, 2016

Are you working with redaction annotations - that's what applyRedactions is for.

In general fields aren't handled until the user changes focus. This is why Submit buttons are preferred. Live interaction is an issue, and it's easy to upset/inconvenience the user, especially if you make changes to a field as they type.

Report · Jun 21, 2016

Ok, no annotations for the moment.

Don't worry about the upseting possibility, this is not my first application.

An idea for the method ?

Thanks.