Combo Box default value

[Rockn]

I am trying to set a default value for a combo box that is a static list
with three items in it. Everything I have found googling has related to
setting the default value in the controls properties using this format:

=[controlname].ItemData(indexnumber)

Using this suggestion hasn't worked so far and I am sure it is a simple
solution.

Thanks.

 

[Ofer Cohen]

It is a Report question isn't it?

If so, then in the combo ControlSource write

=Nz([FieldName],1)

In this examle 1 will be the default - this function will change Null to 1

=============
If I'm in the wrong direction, please explain what do you mean by default

 

[Rockn]

Sorry, it is on a form. I want the default value of the combo box on the
form to be the first item in the list.

Thanks

It is a Report question isn't it?

If so, then in the combo ControlSource write

=Nz([FieldName],1)

In this examle 1 will be the default - this function will change Null to 1

=============
If I'm in the wrong direction, please explain what do you mean by default

--
Good Luck
BS"D

I am trying to set a default value for a combo box that is a static list
with three items in it. Everything I have found googling has related to
setting the default value in the controls properties using this format:

=[controlname].ItemData(indexnumber)

Using this suggestion hasn't worked so far and I am sure it is a simple
solution.

Thanks.

 

[Rockn]

I figured it out.
Using the forms onLoad event

Dim strVar as Long
If IsNull(Me.ControlName) Then
strVar = ControlName.ItemData(0)
End If

Sorry, it is on a form. I want the default value of the combo box on the
form to be the first item in the list.

Thanks

It is a Report question isn't it?

If so, then in the combo ControlSource write

=Nz([FieldName],1)

In this examle 1 will be the default - this function will change Null to
1

=============
If I'm in the wrong direction, please explain what do you mean by default

--
Good Luck
BS"D

I am trying to set a default value for a combo box that is a static
list
with three items in it. Everything I have found googling has related to
setting the default value in the controls properties using this format:

=[controlname].ItemData(indexnumber)

Using this suggestion hasn't worked so far and I am sure it is a simple
solution.

Thanks.