John -- Thanks for that explanation, much appreciated.
Steve
Steve-
Well, it won't work as you originally typed it, either. It must be:
If IsNull([txt-vendor-name].Value)
You can use underscores in names and not have to use the brackets, but a name containing any character other than a letter or number must be surrounded by brackets.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
On Oct 28, 2015, at 1:20 PM, Steve thaw5@suddenlink.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
The VBA editor in Access 2007 does not like statements such as "If
IsNull(txt-vendor-name.Value)", replacing it with "If IsNull(txt -
vendor - Name.Value)". Evidently the editor is auto-correcting by
inserting a space before and after the dash. Is there a way to turn off
this autocorrecting action?
Thanks.
Steve
------------------------------------
Posted by: Steve <thaw5@suddenlink.net>
------------------------------------
------------------------------------
Yahoo Groups Links
Posted by: Steve <thaw5@suddenlink.net>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar