dropdown list format

V

vassilis

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
 
J

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.
 
V

vassilis

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...

John Spencer said:
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?
 
V

vassilis

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....
vassilis said:
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...

John Spencer said:
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
 
Top