SetValue - Out of STring SPace error message

P

Pele

I had pasted the message below to the Macro newsgroup but
didn't get any help. I am hoping somebody in the Forms
newsgroup can help. Alos, a microsoft site (see link)
discussed this problem but I don't know how that helps me.
For your information, I am just using a setvalue command
in a macro to add information into a textbox in a pivot
table.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;130954

==========================================================
I was using the Setvalue command in a macro and an error
window popped up saying

"Out of String Space"

This error baffled me since I had used the same command in
very similar forms and it worked. The set command was
using the following item and expression combination.

Item: [Forms]![3PivotTable Form_YTD]![textYr]

Expression:[Forms]![2Main Switchboard]!
[combo_YTD_year_Select]

Can anybody help me find out what is wrong.

Pele
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top