Bug? Properly formatting fields with "/" in the name, Access 2007

[Guest]

I'm working in VBA in a report where some underlying fields and text boxes
have names containing a "/" in the middle.

Say, I have a field named "One / Two"

If I type:

Me.one

.... then the suggestion for the field "One / Two" pops up. However, when
that's selected, here's what happens:

Me.One / Two

It's not bracketed! Naturally, when you do something with that and press
return, the code editor doesn't recognize that this is one field! Previous
access would recognize that this needs to be bracketed in order to work, ie:

Me.[One / Two]

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...63be&dg=microsoft.public.access.modulesdaovba

 

[Douglas J. Steele]

You do realize the easy workaround is not to use spaces or special
characters in your field names?

 

[Guest]

Doug,

Yes (or, to just be un-lazy and add the brackets manually). But Access 2007
is in beta, recognizes most space issues (just not "/", apparently). Hence
why this was posted as a suggestion and not a question (so maybe MS will read
it or someone could confirm that it isn't just a fluke in my version)

You do realize the easy workaround is not to use spaces or special
characters in your field names?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I'm working in VBA in a report where some underlying fields and text boxes
have names containing a "/" in the middle.

Say, I have a field named "One / Two"

If I type:

Me.one

... then the suggestion for the field "One / Two" pops up. However, when
that's selected, here's what happens:

Me.One / Two

It's not bracketed! Naturally, when you do something with that and press
return, the code editor doesn't recognize that this is one field! Previous
access would recognize that this needs to be bracketed in order to work,
ie:

Me.[One / Two]

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...63be&dg=microsoft.public.access.modulesdaovba

 

[Douglas J. Steele]

Hardly surprising that it has a problem with /, since that could mean you're
trying to do a division. And while Access 2007 is in Beta, I'm pretty sure
that there's little chance of getting additional functionality added at this
time: if they make any changes at this time, it'll likely only be
significant bug fixes, and I'd hardly call this a significant bug.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Doug,

Yes (or, to just be un-lazy and add the brackets manually). But Access
2007
is in beta, recognizes most space issues (just not "/", apparently). Hence
why this was posted as a suggestion and not a question (so maybe MS will
read
it or someone could confirm that it isn't just a fluke in my version)

You do realize the easy workaround is not to use spaces or special
characters in your field names?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I'm working in VBA in a report where some underlying fields and text
boxes
have names containing a "/" in the middle.

Say, I have a field named "One / Two"

If I type:

Me.one

... then the suggestion for the field "One / Two" pops up. However,
when
that's selected, here's what happens:

Me.One / Two

It's not bracketed! Naturally, when you do something with that and
press
return, the code editor doesn't recognize that this is one field!
Previous
access would recognize that this needs to be bracketed in order to
work,
ie:

Me.[One / Two]

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...63be&dg=microsoft.public.access.modulesdaovba

 

[Guest]

I agree that it's not a surprising bug. But, if the autocomplete feature
recognizes that it needs to bracket when there's a space in a field, I'm not
sure why it doesn't treat the "/" the same way.

I agree that it's not a significant bug. But, if it makes a list to get
fixed eventually (even after release), I'll be happy. To me, Beta (especially
Public Beta) is the time to yell "bug" whenever you see one. Everyone knows
you can't fix every single one. However, that doesn't mean that even minor
nuisance bugs shouldn't be reported.

Hardly surprising that it has a problem with /, since that could mean you're
trying to do a division. And while Access 2007 is in Beta, I'm pretty sure
that there's little chance of getting additional functionality added at this
time: if they make any changes at this time, it'll likely only be
significant bug fixes, and I'd hardly call this a significant bug.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Doug,

Yes (or, to just be un-lazy and add the brackets manually). But Access
2007
is in beta, recognizes most space issues (just not "/", apparently). Hence
why this was posted as a suggestion and not a question (so maybe MS will
read
it or someone could confirm that it isn't just a fluke in my version)

You do realize the easy workaround is not to use spaces or special
characters in your field names?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I'm working in VBA in a report where some underlying fields and text
boxes
have names containing a "/" in the middle.

Say, I have a field named "One / Two"

If I type:

Me.one

... then the suggestion for the field "One / Two" pops up. However,
when
that's selected, here's what happens:

Me.One / Two

It's not bracketed! Naturally, when you do something with that and
press
return, the code editor doesn't recognize that this is one field!
Previous
access would recognize that this needs to be bracketed in order to
work,
ie:

Me.[One / Two]

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...63be&dg=microsoft.public.access.modulesdaovba

 

[Douglas J. Steele]

I understand where you're coming from, and I really hate to prolong this
thread, but by the time a Beta becomes Public, it's typically too late to
get changes made.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I agree that it's not a surprising bug. But, if the autocomplete feature
recognizes that it needs to bracket when there's a space in a field, I'm
not
sure why it doesn't treat the "/" the same way.

I agree that it's not a significant bug. But, if it makes a list to get
fixed eventually (even after release), I'll be happy. To me, Beta
(especially
Public Beta) is the time to yell "bug" whenever you see one. Everyone
knows
you can't fix every single one. However, that doesn't mean that even minor
nuisance bugs shouldn't be reported.

Hardly surprising that it has a problem with /, since that could mean
you're
trying to do a division. And while Access 2007 is in Beta, I'm pretty
sure
that there's little chance of getting additional functionality added at
this
time: if they make any changes at this time, it'll likely only be
significant bug fixes, and I'd hardly call this a significant bug.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Doug,

Yes (or, to just be un-lazy and add the brackets manually). But Access
2007
is in beta, recognizes most space issues (just not "/", apparently).
Hence
why this was posted as a suggestion and not a question (so maybe MS
will
read
it or someone could confirm that it isn't just a fluke in my version)

:

You do realize the easy workaround is not to use spaces or special
characters in your field names?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I'm working in VBA in a report where some underlying fields and text
boxes
have names containing a "/" in the middle.

Say, I have a field named "One / Two"

If I type:

Me.one

... then the suggestion for the field "One / Two" pops up. However,
when
that's selected, here's what happens:

Me.One / Two

It's not bracketed! Naturally, when you do something with that and
press
return, the code editor doesn't recognize that this is one field!
Previous
access would recognize that this needs to be bracketed in order to
work,
ie:

Me.[One / Two]

----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the
"I
Agree" button in the message pane. If you do not see the button,
follow
this
link to open the suggestion in the Microsoft Web-based Newsreader
and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...63be&dg=microsoft.public.access.modulesdaovba