tamara
Posts: 26
|
| Posted: 02/08/2006, 10:24 AM |
|
I was wondering if anyone can tell me how to limit displaying a label on a grid or report to just the first seven letters of the value. I can't find it in the label control properties any where.
Thanks,
Tamara
|
 |
 |
dragoon
Posts: 173
|
| Posted: 02/08/2006, 12:16 PM |
|
better return right sql statement than modifying the control value
select
case
when len(column1) > 7 then left(column1,7)
else column1
end as whatever,column2,...
from table
|
|
|
|
gesto
Posts: 42
|
| Posted: 02/14/2006, 6:00 AM |
|
too simple...
in events of the label.. put a 'before show' custom code...
add this line jus as it is...
eventcaller.value = len(eventcaller.value, 7)
|
|
|
|
Oper
Posts: 1195
|
| Posted: 02/20/2006, 9:40 AM |
|
i guess was a tipo gesto "len"
sentence:
Label1.value = left(label1.value,7)
Quote gesto:
too simple...
in events of the label.. put a 'before show' custom code...
add this line jus as it is...
eventcaller.value = len(eventcaller.value, 7)
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
