none
Error number 2055 RRS feed

  • Question

  • Hey Everyone,

    I am trying to set and if statement in an access web app that will change the the Visible property for several Controller Box's but keep getting Error 2055 when the event is triggered. As shown below.

    If [NoteTypeComboBox]="Contact"
    Then 
     SetProperty
       Contact_TYpeLabel
       Visible
       Yes
    Else If [NoteTypeComboBox]="Interview"
    Then
      SetProperty
        Interview_TypeLabel
        Visible
        Yes
    End If

    Error is as follows,

    "An error has Occurred.

    The expression resulted in an overflow because the value is too large for the resulting data type."

    under more Detail

    "Error Failed"

    Macro Name: List:List

    Condition: True:[NoteTypeComboBox]="Contact"

    Action Name:

    Arguments:

    Error Number: 2055


    Any help or insights would be much appreciated.

    Wednesday, January 11, 2017 3:30 PM

Answers

  • Hi,

    Just curious, what is the Row Source of your combobox? Maybe it's bound to a number column?

    If [NoteTypeCombobox]=1

    Just a thought...

    • Marked as answer by Nidant Wednesday, January 11, 2017 3:44 PM
    Wednesday, January 11, 2017 3:39 PM

All replies

  • Hi,

    Just curious, what is the Row Source of your combobox? Maybe it's bound to a number column?

    If [NoteTypeCombobox]=1

    Just a thought...

    • Marked as answer by Nidant Wednesday, January 11, 2017 3:44 PM
    Wednesday, January 11, 2017 3:39 PM
  • Great idea! That was it. Thank you so much .theDBguy

    Wednesday, January 11, 2017 3:44 PM
  • Hi,

    You're welcome. Glad to hear you got it sorted out. Good luck with your project.

    Note to self: 12K

    Wednesday, January 11, 2017 3:49 PM