Input Box not retained

[sargum]

Hi,

I am using MS Access 2002. Here are some details of components I am
working with.

Table is called "Wafer Info"

Field within "Wafer Info" table is "Wafer Name" w/ input mask of
"NM-"00"W#"00"(CCF"000")"

Query is called "Wafer Info List" which basically pulls "Wafer Name"
from "Wafer Info table".

I am trying to make a form that contains a listbox with all the wafer
names, based on info from "Wafer Info List" query. I can do this but
it completely ignores the input mask. How can I get it to retain the
input mask in the form? When I look at just hte query itself, I get a
list of wafer names with input masks in place just fine but not doing
the same thing when results shown in listbox on form, based on this
same query. Why? Does anyone have any suggestions? I do not see how
to set input mask for listbox.

EX: NM-05W#05(CCF337) generated from query shows up as "0505337" in
listbox in form.

Thanks.

S

 

[Barry Gilbert]

An input mask is only used to format the text when inputting data, as in a
table or textbox on a form. It doesn't actually store the data in that
format; just guides the user. Since you cannot directly enter/change data in
a listbox, it will only display data as it is stored in the table.

I think you'll need to do some fancy stuff in the query, using a combination
of the Left and Mid functions.

HTH,
Barry

 

[sargum]

Hi,

Ok, I see. I will try and mess around with mid and left
functions...did so a long time ago, I am sure I can get it. Good idea.

Thanks.
S