B
Bob Waggoner
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?
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?