Gustav Brock
Gustav at cactus.dk
Wed Dec 28 03:26:46 CST 2011
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