andash
Posts: 18
|
| Posted: 12/18/2007, 9:23 PM |
|
Hi,
Can anyone shed some light as to how I can do the following in CCS3.2 & ASP.
In a report and a grid I want to add a text value 'VOL' to a field. If this field is empty however I want to show nothing.
So if {record_value} displays as 15, I want to make this show 'VOL 15'. If the record is empty then I don't want to display anything. I can add the VOL to the HTML area but that still shows when there is no value for {record_value}
Sounds like a simple {record_value}="Voll" & {record_value}.value somewhere but I can't work it out ( been away from this too long)
Thanks in advance
Andrew
_________________
Andrew Asher
www.it3.co.nz |
 |
 |
Oper
Posts: 1195
|
| Posted: 12/19/2007, 3:23 AM |
|
on before show event that field.
if Sender.value > " " then
Sender.value=" VOL " & Sender.value
end if
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
andash
Posts: 18
|
| Posted: 01/09/2008, 2:55 PM |
|
Sweet. Thanks for that. 
_________________
Andrew Asher
www.it3.co.nz |
|
|
|
jsmonkey
Posts: 39
|
| Posted: 01/15/2008, 6:45 AM |
|
I copied along with this and it works for me too, Thank you. Is it possible to add a return between the 2 values? I am trying to combine 2 paragraphs for a click together form letter.
Something like:
if Sender.value > " " then
Sender.value=" VOL " &<BR> & Sender.value
end if
I am trying to do this within a textbox in a beforshow event.
_________________
-J |
|
|
|
mljonzs
Posts: 124
|
| Posted: 01/15/2008, 7:49 AM |
|
jsmonkey - rather than use the <BR> use VBCRLF in your code since you are inside ASP
like this
Sender.value = "VOL " & VbCRLF & Sender.value
_________________
What does not begin WITH God, will end in failure!
|
|
|
|
jsmonkey
Posts: 39
|
| Posted: 01/15/2008, 9:10 AM |
|
Awesome! VBCRLF worked! I was just starting to experiment with & Chr(13) & Chr(10) & when you replied, but I like the clean VBCRLF better.
Thank you!!
_________________
-J |
|
|
|
mljonzs
Posts: 124
|
| Posted: 01/15/2008, 1:33 PM |
|
You are welcome.
And, just for the record, the Chr(10) and Chr(13) would work too.
_________________
What does not begin WITH God, will end in failure!
|
|
|
|
Oper
Posts: 1195
|
| Posted: 01/15/2008, 6:39 PM |
|
<br> will work too
but the text Context has to be defined as HTML
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
