[AccessD] textbox value is null

Good point.

On 28 Dec 2011 at 10:26, Gustav Brock wrote:

> Hi Stuart
> 
> You may add that property Text is available only when the TextBox (or other type of control) has focus.
> 
> /gustav
> 
> 
> >>> stuart at lexacorp.com.pg 28-12-2011 04:21 >>>
> .Value is the underlying "value" of the textbox.  It does not change during editing of the 
> textbox. Only when the control loses focus.  It can be a string, a number or a Null.
> 
> .Text is the text string currently *displayed*  contents of the textbox, it changes as the content 
> of the textbox is edited.  It is always a string.
> 
> Note that  because .Text is a string, even if the underlying data is a Null, .Text is not - it is an 
> empty string (that's why the sample code tests for an empty string, not a null.)
> 
> -- 
> Stuart
> 
> 
> On 27 Dec 2011 at 21:54, jwcolby wrote:
> 
> > Yep, that works.  I have gotten used to always using .Value which apparently is not valid till 
> > AfterUpdate.
> > 
> > Thanks,
> > 
> > John W. Colby
> > Colby Consulting
> > 
> > Reality is what refuses to go away
> > when you do not believe in it
> > 
> > On 12/23/2011 4:00 PM, Stuart McLachlan wrote:
> > > Try this:
> > >
> > > Private Sub txtA_KeyUp(KeyCode As Integer, Shift As Integer)
> > >      txtB = "C:\Access\"&  txtA.Text&  IIf(txtA.Text = "", "", "\")
> > > End Sub
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>