Thanks Dave!
Tracy
>>I want a listbox's rowsource to be:
>>
>>formfield, LEFT(profiler,100)
>>
>>but it won't let me. It allows me to enter that value but when the form runs I receive a syntax error. I'm doing a sql select into a table but I don't want to do a sql select LEFT(profiler,100) because I need the entire field for other purposes and I want the fieldname to remain the same and not become exp_2, etc.
>>
>>Is it possible?
>>
>>TIA,
>>Tracy
>
>to avoid a renaming like 'exp_2' I do this...
>
>SELECT LEFT(Profiler,100) AS MyNewName FROM Customer INTO CURSOR TestQuery
>
>then the field is called MyNewName...
>
>and I make the RowSourceType = 2
>and RowSource = TestQuery
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"