dropdown list format

[Guest]

hello there...
i noticed that the values from the drop down menu are different that the
value format that appear..for example...value format is something like
@@-@@-@@ but in the drop down menu looks like @@@@@@...is it possible to
make them look the same?
thanks

 

[Duane Hookom]

Apply formatting in the Row Source SQL.

 

[Guest]

yes but how i can do that?

Apply formatting in the Row Source SQL.

 

[John Spencer]

It would help, if you posted the row source. To format a column use the Format
function in the record source

Format([Your Field],"@@@-@@-@@") as [An Alias Name]

If this is the bound column, then you will have a problem as the formatted value
of the combo's list will not equal a stored value if that value does not
actually contain the value with the dashes in it.

 

[Guest]

thats my row source

SELECT

.userID,

.rusname FROM

;

the format property from the general tab is @@-@@-@@ but the combobox doesnt
take affect from this format...

It would help, if you posted the row source. To format a column use the Format
function in the record source

Format([Your Field],"@@@-@@-@@") as [An Alias Name]

If this is the bound column, then you will have a problem as the formatted value
of the combo's list will not equal a stored value if that value does not
actually contain the value with the dashes in it.

yes but how i can do that?

 

[Guest]

i got it finaly...u must format the field from the source table too...i was
thinking that the input mask work and format doing exactly tha same work....

thats my row source

SELECT

.userID,

.rusname FROM

;

the format property from the general tab is @@-@@-@@ but the combobox doesnt
take affect from this format...

It would help, if you posted the row source. To format a column use the Format
function in the record source

Format([Your Field],"@@@-@@-@@") as [An Alias Name]

If this is the bound column, then you will have a problem as the formatted value
of the combo's list will not equal a stored value if that value does not
actually contain the value with the dashes in it.

yes but how i can do that?

:

Apply formatting in the Row Source SQL.

--
Duane Hookom
MS Access MVP
--

hello there...
i noticed that the values from the drop down menu are different that the
value format that appear..for example...value format is something like
@@-@@-@@ but in the drop down menu looks like @@@@@@...is it possible to
make them look the same?
thanks