November 29, 2012 at 12:20 am
the character is changed to a number when I send the info to a textbox.
look at my design and my expression
=[Combo0] & "- " & [Combo2] & "" & [Text27] & "- " & [Combo4] & "" & [Combo6] & "- " & [Text25]
How do I need to build this expression?
November 29, 2012 at 11:45 am
maybe I am not explaining this correctly.
HaulerID = 2
Asset =C
Asset Number =6565
Material =A
Classfication =T
Year =2012
Waste Hauler Account Number should be 2-C6565-AT-2012
But the output is 2-26565-11-2012
this is the expression I am using
=[Combo0] & "- " & [Combo2] & "" & [Text27] & "- " & [Combo4] & "" & [Combo6] & "- " & [Text25]
November 29, 2012 at 11:59 am
sasansamani (11/29/2012)
maybe I am not explaining this correctly.
I'm afraid I don't have an answer for you but I don't believe the problem is the explanation per se. It's just that most of us aren't MSAccess experts. Might I recommend you try Experts Exchange as well as here?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 29, 2012 at 12:17 pm
I suggest you look at the RowSource and BoundColumn properties of each item. My guess is that you have some sot of ID field that is the BoundColumn. This is the value that will be returned when you reference it in the expression.
November 29, 2012 at 4:19 pm
thank you very much.
I think the problem is related to BoundColumn Property
http://office.microsoft.com/en-us/access-help/boundcolumn-property-HA001232723.aspx
let me see what I can do
November 29, 2012 at 5:01 pm
Hi
Use the cstr function to convert numeric values into text which can then be concatenated into your string. Test for null values and replace them with a valid character or string.
Also make sure that the value you want to retrieve from the combo control is the bound value as you have discovered. If it is not, then you will also need to specify the column number (numbering starts at zero). Therefore [Combo2](1) should retrieve the value from the second column of your control.
Cheers
Rowan
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply