[AccessD] With / End With or not?

[Gustav Brock]

Hi Bill

No. You mix up things. The original question, thus my last comment, was about execution speed.

The other topic is about code readability. And that is right: Writing highly readably code often takes longer time. Just think about how many key entries you would save by not indenting your code.
Regard it as a long-term investment; it will pay back after some years – the day when you review your code.

/gustav

Fra: Bill Benson <bensonforums at gmail.com<mailto:bensonforums at gmail.com>>
Sendt: 17. september 2021 14:16
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>
Cc: Gustav Brock <gustav at cactus.dk<mailto:gustav at cactus.dk>>
Emne: Re: [AccessD] With / End With or not?

You're joking right? It takes FAR less of my OWN microseconds to make use of With and use the dots only, than to type or copy paste Target all those times!

On Fri, Sep 17, 2021 at 6:03 AM Gustav Brock via AccessD <accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>> wrote:
Hi Bill

Perhaps, and we can all believe, but who knows?
My believe is, that we are discussing microseconds, thus not worth any efforts for any normal scenario.

/gustav

Fra: Bill Benson <bensonforums at gmail.com<mailto:bensonforums at gmail.com>>
Sendt: 17. september 2021 11:47
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>
Cc: Gustav Brock <gustav at cactus.dk<mailto:gustav at cactus.dk>>
Emne: Re: [AccessD] With / End With or not?

Gustav, I believe you could AT LEAST have left With Target in there and got a performance boost. Small, but real.

On Tue, Sep 14, 2021 at 5:04 AM Gustav Brock via AccessD <accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com><mailto:accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>> wrote:
Hi Arthur

If any gain at all, it will more likely be microseconds.

The use or not of With-End With is rather a matter of preferred coding style. Indeed, if you type in an environment like Visual Studio or Visual Studio Code (yes, you can code VBA with this) where IntelliSense predicts quite well what you intend to type.

The problem with With-End With is, that you easily loose track of the object, indeed when nested.
For fun, I took an old function of mine with what I considered "smart" use of With-End With tending the unreadable and rewrote it in "clean" style.

<snip>