Oops. I thought it was a followup to a different question.

It took me a bit to see the humor you saw.

(And I guess my response was completely off topic!)

Sorry <vbg>,

Lady Layla wrote:
>
> Thanks for the laugh Dave -- I needed one this am
>
> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> news:42381E70.E9D5A108@netscapeXSPAM.com...
> : I don't use Access, but you can see how excel truncates strings by...
> :
> : 1. Create a new workbook.
> : in A1 of sheet1, put this:
> : =rept("asdf ", 500)
> : In A2, put =len(a1)
> : you'll see 2500
> : save this workbook (but don't close it)
> :
> : 2. Create new workbook.
> : in A1 of sheet1, put a formula that points back at that A1 with
> : the long string
> : It should look something like: =[book1.xls]Sheet1!$A$1
> : In A2, put =len(a1)
> : you'll see 2500.
> :
> : 3. Close that workbook that you created in step 1.
> :
> : 4. Select A1 (of the second workbook)
> : Hit F2|Enter (to reevalate the formula)
> : You'll see the string change and the length change in A2.
> :
> : Same kind of thing happens using Access (but I don't speak the Access).
> (Yeah,
> : I like that phrase!)
> :
> : Dave Unger wrote:
> : >
> : > Dave,
> : >
> : > Please expand on your "truncation" comment. I've been having trouble
> : > today with my messages being truncated, accessed through Google groups.
> : > Don't know why, hasn't happened before.
> : >
> : > Thanks,
> : >
> : > Dave Unger
> :
> : --
> :
> : Dave Peterson

--

Dave Peterson