[AccessD] textbox value is null

Stuart McLachlan stuart at lexacorp.com.pg
Fri Dec 23 15:00:09 CST 2011


Try this:

Private Sub txtA_KeyUp(KeyCode As Integer, Shift As Integer)
    txtB = "C:\Access\" & txtA.Text & IIf(txtA.Text = "", "", "\")
End Sub

-- 
Stuart

On 23 Dec 2011 at 15:31, jwcolby 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
> Website: http://www.databaseadvisors.com
> 






More information about the AccessD mailing list