Problem with Access 97 lookup query decimals

In a database that has a front and back end (mde), we have a lookup in a
subform that retrieves cut sizes from a table in another database (linked).
The size format is Standard / 4 decimals. I've managed to set the format of
that particular field in my database lookup field to Standard 4. I make the
mde and when I use it, I get 2 decimals instead of 4.

I went into the query (of the drop down list) properties and changed the
property to standard 4 decimals. I saved the query and it retained the
property settings. I created the mde from the original. When I use the drop
down in the mde, it does not give me four decimals.

What can I do to force the lookup to 4 decimals?

One of our IT guys helped me with this one. The formatting goes in the query
field.
Bob

"Bob Waggoner" wrote:

In a database that has a front and back end (mde), we have a lookup in a
subform that retrieves cut sizes from a table in another database (linked).
The size format is Standard / 4 decimals. I've managed to set the format of
that particular field in my database lookup field to Standard 4. I make the
mde and when I use it, I get 2 decimals instead of 4.

I went into the query (of the drop down list) properties and changed the
property to standard 4 decimals. I saved the query and it retained the
property settings. I created the mde from the original. When I use the drop
down in the mde, it does not give me four decimals.

What can I do to force the lookup to 4 decimals?