By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

formatting listbox

P: n/a
Hi all, I've got a listbox with its rowsource set to a table, problem
is when it brings down the numbers, 2 of my fields have alot of 0's ex:
100.000000000 cases

was wondering how i could format this listbox in acess 2k3, thanks all!

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Br
Beacher <be*****@gmail.com> wrote:
Hi all, I've got a listbox with its rowsource set to a table, problem
is when it brings down the numbers, 2 of my fields have alot of 0's
ex: 100.000000000 cases

was wondering how i could format this listbox in acess 2k3, thanks
all!


Format the field in the recordsource (query) of the listbox. (eg.
ValueSCR: Format([Value], "0.00")
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #2

P: n/a
I'm setting it in code, and its giving me a syntax error, does this
look ok to you?

lstFilter.RowSource = "SELECT TOP 100 PERCENT
dbo.Zrep_Schedule_Attain.MatDate, dbo.Zrep_Schedule_Attain.Plant,
dbo.Zrep_Schedule_Attain.MaterialNum,
dbo.Zrep_Schedule_Attain.KGsPlanned,
dbo.Zrep_Schedule_Attain.KGsProduced,
Format(dbo.Zrep_Schedule_Attain.KGsPlanned /
dbo.MaterialGeneral.NetWeight, "0.00") AS CasesPlanned,
Format(dbo.Zrep_Schedule_Attain.KGsProduced /
dbo.MaterialGeneral.NetWeight, "0.00") AS CasesProduced FROM
dbo.Zrep_Schedule_Attain INNER JOIN dbo.MaterialDesc ON
dbo.Zrep_Schedule_Attain.MaterialNum = dbo.MaterialDesc.MaterialNum
INNER JOIN dbo.MaterialGeneral ON dbo.Zrep_Schedule_Attain.MaterialNum
= dbo.MaterialGeneral.MaterialNum WHERE
(dbo.Zrep_Schedule_Attain.MaterialNum > '699999') AND
dbo.Zrep_Schedule_Attain.MatDate = " & "'" & Form_Schedule!cbodate &
"'" & " ORDER BY dbo.Zrep_Schedule_Attain.MatDate,
dbo.Zrep_Schedule_Attain.Plant, dbo.Zrep_Schedule_Attain.MaterialNum"

Nov 13 '05 #3

P: n/a
Sorry, forgot to mention, it's an ADP

Nov 13 '05 #4

P: n/a
I used Cast(value as int(3)) and it worked fine

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.