Re: Bang vs. Dot - final answer


Steve Jorgensen wrote:
> On 30 Sep 2005 06:48:10 -0700, "lylefair" <lylefair@xxxxxxxx> wrote:

> Apparently, YMMV on this issue. Personally - I've had the problem with
> multiple clients including some who had the problem before calling me in, some
> cases while I was doing development enhancements to existing projects, and
> some cases with new projects I was creating for clients from scratch.

Your post left me puzzled. Why would our experiences be so dissimilar?
Perhaps, it is because I seldom or never use the default properties for
objects like controls and fields.

For example, I write "rcs.Fields("LastName").Value = "Smith"
and "Me.LastName.Value="Smith"
rather than
"rcs.Fields("LastName") = "Smith"
and "Me.LastName="Smith"

I am aware that this may be slower, but I doubt that it is noticeably
slower. I am not suggesting that it should be anyone's preferred coding
style, except for me.

But it may prevent Access/VBA's confusing an object and its properties,
sonething that, I suppose, could cause corruption.

Of course, using the bang, would also prevent this
confusion->corruption.

.