default value of combo box?

[JethroUK©]

How might i express the default value of a combobox (start_date) as being
the first item in the existing list?

default value =[start_date].[Itemdata(0)]

 

[Douglas J. Steele]

Regardless of what the data type is, the default value property is a string,
so it must have quotes around it.

Try putting code similar to below in the form's Load event:

Me.MyCombo.DefaultValue = Chr$(34) & Me.MyCombo.ItemDate(0) & Chr$(34)

 

[JethroUK©]

it doesn't seem to like that - thanks anyhow - the fact that default value
has an expression builder suggests it will accept an expression - i've even
tried the expression builder and whilst it shows combo box object, it
doesn't show 'Itemdata' in the list of properties (virtually everything but)

Regardless of what the data type is, the default value property is a string,
so it must have quotes around it.

Try putting code similar to below in the form's Load event:

Me.MyCombo.DefaultValue = Chr$(34) & Me.MyCombo.ItemDate(0) & Chr$(34)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

How might i express the default value of a combobox (start_date) as being
the first item in the existing list?

default value =[start_date].[Itemdata(0)]

 

[Douglas J. Steele]

Really? It worked fine for me when I tested before posting.

What problem are you having?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

it doesn't seem to like that - thanks anyhow - the fact that default value
has an expression builder suggests it will accept an expression - i've
even
tried the expression builder and whilst it shows combo box object, it
doesn't show 'Itemdata' in the list of properties (virtually everything
but)

Regardless of what the data type is, the default value property is a string,
so it must have quotes around it.

Try putting code similar to below in the form's Load event:

Me.MyCombo.DefaultValue = Chr$(34) & Me.MyCombo.ItemDate(0) & Chr$(34)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

How might i express the default value of a combobox (start_date) as being
the first item in the existing list?

default value =[start_date].[Itemdata(0)]

 

[JethroUK©]

my fault - i'd mis-typed it so got #Error - sorry ~

but it works now:

Start_Date.DefaultValue = "=[Start Date].[itemdata](0)"

)

which is char 34? it seems to work without it

Really? It worked fine for me when I tested before posting.

What problem are you having?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

it doesn't seem to like that - thanks anyhow - the fact that default value
has an expression builder suggests it will accept an expression - i've
even
tried the expression builder and whilst it shows combo box object, it
doesn't show 'Itemdata' in the list of properties (virtually everything
but)

Regardless of what the data type is, the default value property is a string,
so it must have quotes around it.

Try putting code similar to below in the form's Load event:

Me.MyCombo.DefaultValue = Chr$(34) & Me.MyCombo.ItemDate(0) & Chr$(34)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



How might i express the default value of a combobox (start_date) as being
the first item in the existing list?

default value =[start_date].[Itemdata(0)]

 

[Douglas J. Steele]

Chr$(34) is a double quote.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

my fault - i'd mis-typed it so got #Error - sorry ~

but it works now:

Start_Date.DefaultValue = "=[Start Date].[itemdata](0)"

)

which is char 34? it seems to work without it

Really? It worked fine for me when I tested before posting.

What problem are you having?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

it doesn't seem to like that - thanks anyhow - the fact that default value
has an expression builder suggests it will accept an expression - i've
even
tried the expression builder and whilst it shows combo box object, it
doesn't show 'Itemdata' in the list of properties (virtually everything
but)


message
Regardless of what the data type is, the default value property is a
string,
so it must have quotes around it.

Try putting code similar to below in the form's Load event:

Me.MyCombo.DefaultValue = Chr$(34) & Me.MyCombo.ItemDate(0) & Chr$(34)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



How might i express the default value of a combobox (start_date) as
being
the first item in the existing list?

default value =[start_date].[Itemdata(0)]

 

[JethroUK©]

ah! thanx

Chr$(34) is a double quote.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

my fault - i'd mis-typed it so got #Error - sorry ~

but it works now:

Start_Date.DefaultValue = "=[Start Date].[itemdata](0)"

)

which is char 34? it seems to work without it

Really? It worked fine for me when I tested before posting.

What problem are you having?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



it doesn't seem to like that - thanks anyhow - the fact that default value
has an expression builder suggests it will accept an expression - i've
even
tried the expression builder and whilst it shows combo box object, it
doesn't show 'Itemdata' in the list of properties (virtually everything
but)


message
Regardless of what the data type is, the default value property is a
string,
so it must have quotes around it.

Try putting code similar to below in the form's Load event:

Me.MyCombo.DefaultValue = Chr$(34) & Me.MyCombo.ItemDate(0) & Chr$(34)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



How might i express the default value of a combobox (start_date) as
being
the first item in the existing list?

default value =[start_date].[Itemdata(0)]