assigning recorrdset value to a textbox

's Computer Specifications

Hi,
I have a stored procedure which returns a single value, assigned toa
recordset variable, rst. I want to put this value into a textbox on an Access
Project form. However, txtbx.value = rst doesn't work.

Am I right in thinking that I have to convert the rst value into a string
(or other compatible form for the text box value), and if so, how do I do
this?

many thanks,

Pete

's Computer Specifications

I have resolved this. by using Val(rst.Getstring)

"Italian Pete" wrote:

> Hi,
> I have a stored procedure which returns a single value, assigned toa
> recordset variable, rst. I want to put this value into a textbox on an Access
> Project form. However, txtbx.value = rst doesn't work.
>
> Am I right in thinking that I have to convert the rst value into a string
> (or other compatible form for the text box value), and if so, how do I do
> this?
>
> many thanks,
>
> Pete

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assigning textbox value...	116	Microsoft Access	3	2nd Dec 2008 08:06 PM
assigning a value to a textbox/label control in ASP.NET	Rahul Chatterjee	Microsoft ASP .NET	1	25th Sep 2008 03:04 AM
Assigning Row Number to TextBox	Ayo	Microsoft Excel Misc	0	30th May 2008 08:24 PM
Assigning a value to an unbound textbox	=?Utf-8?B?TVMgQWNjZXNzIE5ld2JpZQ==?=	Microsoft Access VBA Modules	4	14th Jan 2007 04:25 PM
Assigning variable to a TextBox	VBeejit	Microsoft Access Form Coding	5	19th Nov 2003 05:36 AM