Combo Box to show 01 not 1

[Bob Vance]

In my combo box row source is 01;02;03; but when i select say 02 only 2 is
showing, Control Source is DateOfBirth/Number Field

 

[Al Campagna]

Bob,
The Row Source Type should be Value List, and the
Row Source would be text...
"01";"02";"03"
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Bob Vance]

Thanks Al, changed the field from number to text now its showing 02
Regards Bob

 

[Tom Wickerath]

Hi Bob,

For a numeric field, set the Format property to: 00


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Bob Vance]

Thanks Tom, the problem is with doing that when I use this control I still
get 7 Mary and not 07 Mary in tbName...Regards Bob

Private Sub cmdEnterDateMare_Click()
Me.tbName.value = cbDateOfBirth.value & " " & Me.CbMotherName.value


End Sub

 

[Tom Wickerath]

Hi Bob,

Me.tbName.value

Is tbName a text box? Unbound?

You might try this:
Me.tbName.value = Format(cbDateOfBirth.value, "00") & " " _
& Me.CbMotherName.value


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Bob Vance]

Brilliant Tom, worked the text box was unbound
Regards Bob V