[AccessD] textbox value is null

Charlotte Foust charlotte.foust at gmail.com
Fri Dec 23 15:45:38 CST 2011


I'm not sure value will work the way you want it to, but you might try
using the beforeupdate of the first textbox to write the text in the box
(not the value) to the second textbox.  I may be confusing VB.Net and VBA,
so don't take my advice as gospel.

Charlotte Foust

On Fri, Dec 23, 2011 at 12:31 PM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> I am trying to use the value of a text box I am typing into to create a
> string in another text box.  IOW I type 'a' in txt1 and txt2 is set to
> 'C:\Access\a\'.  The C:\Access is a constant directory location and I am
> inserting 'C:\Access\' & txtA.Value & '\' into txtB.
>
> However txtA.Value is NULL! until I move out of the text box (after
> update) so the string I am building looks like 'C:\Access\\' since a null
> is being inserted between the 'C:\Access\' and the '\'.  I thought I was
> going to use txtA.OnKeyDown etc.  No dice.  I never really knew about this
> behavior and don't quite know how to work around it.
>
> Any thoughts?
>
> --
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
>
>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>
>
>



More information about the AccessD mailing list