dot VS bang

[Bob Hughes]

I have been using the format
Me!FieldName = "xxx" for a long time all of a sudden I am finding that I
need to use
Me.FieldName = "xxx"


This seems to be also true for
Forms.x
Reports.x

Can someone please explain when you should use a "!" instead of a "."? I
can find no place where the dot does not work.

Bob

 

[tina]

see MVP Dirk Goldgar's "standard" response to the question (which you can
also easily find by googling "dot vs bang" at www.groups.google.com,
Advanced Search).

http://groups.google.com/group/micr...+author:goldgar&rnum=2&hl=en#7ea1e64b5d2c256d

hth

 

[Bob Hughes]

I'm embarrassed not to have tried that first. My code just started to fail
after a major fix. Create new DB & import old, because of problems
discovered when using Access 2003. I have done a "replace all" changing
"!" to ".". Keeping my fingers crossed.
This was to be such a simple project <Sigh>

Bob

see MVP Dirk Goldgar's "standard" response to the question (which you
can also easily find by googling "dot vs bang" at
www.groups.google.com, Advanced Search).

http://groups.google.com/group/microsoft.public.access.formscoding/brow
se_frm/thread/d66ef658d78544cb/7ea1e64b5d2c256d?lnk=st&q=dot+vs+bang+gr
oup:microsoft.public.access*+author:dirk+author:goldgar&rnum=2&hl=en#7e
a1e64b5d2c256d

hth

TO reply via e-mail, change the xxx in the address to bob_

 

[tina]

This was to be such a simple project <Sigh>

in Access?? <bg>

 

[Pat Hartman\(MVP\)]

I would have replaced Me! with Me. - replacing all bangs with dots may also
cause errors since they are not always interchangeable.

 

[Bob Hughes]

I know, but one can always dream!

in Access?? <bg>

 

[Bob Hughes]

True, but I was desperate. I had found that reports! and forms! also caused
a problem when I ran a 2K mde file with 2003

Bob
PS I can always go back

 

[tina]

I know, but one can always dream!

but if it were simple, what fun would it be?