Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text Box Control Syntax Error? (A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8)

    I have the following in a Text Box control named DatabaseStatusDescription

    =IIf([CurrentDb].[Properties]("AllowBypassKey").[Value]=-1,"Development","Production")

    and it is returning #Name?

    This same code works fine in a2k thru a2k3

    Any thoughts?


    Thanks, John

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Text Box Control Syntax Error? (A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-

    I would suggest you do this on the OnLoad Event iof the form so you can step through the code and see where the error is. Referencing VB objects in control is a risky approach and very difficult to troubleshoot - and I think some of the properties of the CurrentDB object have changed in 2007 - for one thing there are many more.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •