Display fixed decimal place in Access forms

[skholm]

How do I get 4 decimal places to display in Access 2007 forms combo box?
The table fields are set up like:
ChNew - Number, Integer (Key) (0 - 830)
RptRXMobTX - Number, Single, Fixed, 4 (806.0000 to 823.9875)
RptTXMobRX - Number, Single, Fixed, 4 (851.0000 to 868.9875)
The Combo Box displays only 2 decimal places - not 4
SELECT tbl800MHzChannels.ChNew, tbl800MHzChannels.RptTXMobRX,
tbl800MHzChannels.RptRXMobTX FROM tbl800MHzChannels ORDER BY
tbl800MHzChannels.ChNew;
Column Width 0";1";1" - Select and Display the Single Fixed 4
Queries and Reports are OK
I don't recall having this problem with Win 2 K or XP. I did set Win Vista 4
decimal places but din't help.
Regards, Steve

 

[Dirk Goldgar]

How do I get 4 decimal places to display in Access 2007 forms combo box?
The table fields are set up like:
ChNew - Number, Integer (Key) (0 - 830)
RptRXMobTX - Number, Single, Fixed, 4 (806.0000 to 823.9875)
RptTXMobRX - Number, Single, Fixed, 4 (851.0000 to 868.9875)
The Combo Box displays only 2 decimal places - not 4
SELECT tbl800MHzChannels.ChNew, tbl800MHzChannels.RptTXMobRX,
tbl800MHzChannels.RptRXMobTX FROM tbl800MHzChannels ORDER BY
tbl800MHzChannels.ChNew;
Column Width 0";1";1" - Select and Display the Single Fixed 4
Queries and Reports are OK
I don't recall having this problem with Win 2 K or XP. I did set Win Vista
4
decimal places but din't help.
Regards, Steve

How about using the Format function to explicitly convert the numbers to
strings with four decimal places:

SELECT
ChNew,
Format(RptTXMobRX, "0.0000"),
Format(RptRXMobTX, "0.0000")
FROM tbl800MHzChannels
ORDER BY ChNew;

 

[skholm]

Thanks Dirk - That fixes the problem - Of course I would still like to figure
out why it happens with Vista/07 but not with 2K or XP/03
Best Regards - Steve

 

[Dirk Goldgar]

Thanks Dirk - That fixes the problem - Of course I would still like to
figure
out why it happens with Vista/07 but not with 2K or XP/03

Sorry, I don't know and have no way to test it at the moment.