Wrong type of data for listbox

Posted on 2003-11-13
Medium Priority
Last Modified: 2013-12-18
I've got a form with a listbox in it. It looks up data from a view using the formulae
DbColumn("" : "NoCache"; ""; "2a. Fluids in use"; 2)
Unfortunately the data in column 2 are numbers, and so the listbox returns an error. How can I convert the values it sees into text? I'd prefer not to have to define the field displayed in column 2 as text as I want to work on the numbers elsewhere. I could create a hidden column with some code in it to convert the numbers to text and then look that one up I guess, but can't find a suitable command (only for text to number)
Question by:StuartOrd
  • 2
LVL 31

Expert Comment

ID: 9743278
@Text(DbColumn("" : "NoCache"; ""; "2a. Fluids in use"; 2))
LVL 31

Accepted Solution

qwaletee earned 500 total points
ID: 9743280
Well, fixing your typo...
@Text(@DbColumn("" : "NoCache"; ""; "2a. Fluids in use"; 2))

Author Comment

ID: 9743420
Thanks, qwaletee
I'm still working on the others ones, you'll gather....

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question