Skip to main content
G
gérardg80972918
Participating Frequently
June 21, 2016
Question

Ole - Applying focused field modification

  • June 21, 2016
  • 1 reply
  • 370 views

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 ?

This topic has been closed for replies.

1 reply

T
Test Screen Name
Legend
June 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.

G
gérardg80972918Author
Participating Frequently
June 22, 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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices