Re: [MS_AccessPros] Issue with two identical set of controls

Rod-

It sounds like the field at one time was Text but now is a number. It will display with a leading zero if there's a Format property defined of "000".

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)




On Jan 6, 2015, at 5:14 AM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Rod,


Please provide the data types of the bound column and the related field. Row sources with data sources might be ideal information.


Duane Hookom, MVP

MS Access

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: MS_Access_Professionals@yahoogroups.com
> Date: Mon, 5 Jan 2015 19:09:24 -0800
> Subject: [MS_AccessPros] Issue with two identical set of controls
>
>
>
> I have create a combo box and text box pair. The combo box is used to
> select a value (business code) and the text box will display the
> associated title of the code.
>
> i.e. 014 Retail Sale
>
> a second pair is used for city business code
>
> i.e. 28 Retail Sale
>
> both pairs are setup identical. The problem is none of the values have
> leading zero ( in the table list) but the business code always
> displays as the 3 digit number with leading zero. The city business
> never displays the leading zero. Not sure if I am missing something.
> Would like the display to be consistent. Originally the city business
> codes were defined as 3 digit numbers with leading zero but when
> selected the text would never appear if there was a leading zero.
>
> The combo box use a query to define selection list. The query returns
> 3 columns. The second column is the value and the 3 column is the
> text.
>
> The text boxes are defined by "=[cbo_businesscode].[column](2)" and
>
> "=[cbo_citybusinesscode].[column](2)" respectfully.
>
> Currently both source table number have no leading zeros.
>
> Any ideas?
> Rod
>
>

------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links







------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/