>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.
>
>
> "Douglas J. Steele" wrote:
>
>> 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
>>
http://I.Am/DougSteele>> (no e-mails, please!)
>>
>>
>> "Alex Gordin" <AlexGordin[ at ]discussions.microsoft.com> wrote in message
>> news:D23D95F5-2C3E-40E0-BF77-9A6DFCD74FA8[ at ]microsoft.com...
>> > 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)
>> >
>> > "Douglas J. Steele" wrote:
>> >
>> >> You do realize the easy workaround is not to use spaces or special
>> >> characters in your field names?
>> >>
>> >> --
>> >> Doug Steele, Microsoft Access MVP
>> >>
http://I.Am/DougSteele>> >> (no e-mails, please!)
>> >>
>> >>
>> >> "Alex Gordin" <AlexGordin[ at ]discussions.microsoft.com> wrote in message
>> >> news:1211F037-1E9E-48A7-A26A-AD5DB95F63BE[ at ]microsoft.com...
>> >> > 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/community/en-us/default.mspx?mid=1211f037-1e9e-48a7-a26a-ad5db95f63be&dg=microsoft.public.access.modulesdaovba>> >>
>> >>
>> >>
>>
>>
>>