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! 4 2033
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
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"
Sorry, forgot to mention, it's an ADP
I used Cast(value as int(3)) and it worked fine This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: amber |
last post by:
Hello.
Can someone tell me what I may be doing wrong here?
I'm using the code (lboxRP is a listbox):
Dim newRPindex As Integer
newRPindex = Me.lboxRP.FindString(RP)...
|
by: Sue |
last post by:
When I try to use the following expression,
Format(DateSerial(Year(Date),9,1), "mmm dd, yyyy"), as an item in the value
list of a listbox, the month and day appear on one line and the year appears...
|
by: Shmulik |
last post by:
How can I bind to a data source and express a format?
For example:
Let's say I have a function that returns an array of double, like so:
double myVals= MyFunctions (param1, ..., paramN);
I...
|
by: Chris Leuty |
last post by:
I am populating a multiselect Listbox from a dataset, with the content of
the listbox filled by one table, and the selections determined from another
table. So far, I have been keeping the dataset...
|
by: pallabs |
last post by:
I'm new to asp.net and is having problems doing the following:
1. The tab sequence in a asp form is not working properly. The page is
a login form and tabindex is set to 0 for username, 1 for...
|
by: Hendrik van Rooyen |
last post by:
I am populating a listbox from a directory that looks like this:
variable_dict = {"funny_long_or_short_variable_name_as_key": (2,45),......
the tuple represents a "card, line" pair.
medf is a...
|
by: fatima.issawi |
last post by:
Hello,
I am creating a web page using c# and asp.net. I am trying to populate
a list box by reading text from a file.
The text in the file has leading spaces in order to show a hierarchy of...
|
by: Rotsey |
last post by:
Hi,
I have written a custom multi column listbox control that I pass a
datatable to.
the issue is that if there are date fields then these may
be in the wrong format or any other field...
|
by: dbuchanan |
last post by:
I want to fill a textbox or a label or with lines from a listbox. I want to
preserve the lline for line as it comes from the list box. I do not want the
test to run-on. I suppose it is okay to wrap...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |