Error number 2055

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.

Answer 1

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...

Answer 2

Great idea! That was it. Thank you so much .theDBguy

Answer 3

Hi,

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

Note to self: 12K