Page 1 of 3 123 LastLast
Results 1 to 15 of 31
  1. #1
    sergran is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    115

    empty space start combo


    hello, how can I clear a space at the beginning of a text box?
    Let me explain: I use the space bar key instead of the tab being a text and when I type the space key, as well as move the focus to the text box, rightly I insert a space. Now I would need a code to enter in Event "On On" that gave me the gates empty

    I tried it with
    Code:
     If KeyAscii = 32 Then[parole].SetFocus
    Me.parole.Value = ""
    End If
    thaks
    hello
    Last edited by RuralGuy; 09-21-2013 at 08:29 AM. Reason: Translated the Title

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I guess I would ask "why are you using the space bar"?

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    As Allan suggested,

    Quote Originally Posted by sergran View Post

    ...Let me explain: I use the space bar key instead of the tab being a text and when I type the space key, as well as move the focus to the text box, rightly I insert a space...Now I would need a code to enter in Event "On On" that gave me the gates empty...
    makes sense to you, no doubt, but it makes no sense to Allan or myself, nor, I suspect, will it make sense to anyone else!

    Sit back, take a deep breathe, and try to explain again, so that we can help you.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    sergran is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    115
    in fact, I understand that this may seem strange ...
    I have a caselal text where they completed the word I type and then is copied and added in another text box where there are other words.
    Basically if I have to write Walt Disney character Goofy, Goofy write then pressing the "space", Goofy is copied into the text box below, then the focus back on and I type character etc etc.
    The press space instead of Tab helps me because it's like if you were writing to a file in Word.
    Hello

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I guess I'm just dense but that does not really help me understand what you are doing. Is there some other program running at the same time as your Access program?

  6. #6
    sergran is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    115
    No, only an access mask that allows me to write a review for helping me to insert an audio CD with more comfort words
    Hello

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm going to take some guesses here. You could put code in the OnEnter event of your next Control that removes any leading spaces. Would that work for you?

  8. #8
    sergran is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    115
    It could be a solution .. you could give me an example? hello thanks

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is the "next" control a bound control? Does it have a ControlSource?

  10. #10
    sergran is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    115
    .... but good questions to which you do not know any way to respond. If it's not a problem, I am attaching the db
    thanks
    hello

    Empty space.zip

  11. #11
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    See if this does what you need.
    Attached Files Attached Files

  12. #12
    sergran is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    115
    Sorry but the problem is not solved ... after I typed a word in the text box "words" and hit the space after the word is inserted in the text box "review track 01" and the focus returns to the text box "words", is the space
    I give you an example.
    I write "the" -> I press space -> then if I write test, I have to clear the space of the text box "review track 01"
    thanks
    Hello

  13. #13
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is this closer to what you want?
    Attached Files Attached Files

  14. #14
    sergran is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    115
    it is perfect ... thank you

  15. #15
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're welcome. You'll notice there is a lot of code you no longer need and you can't put a "space" in the string any longer.

Page 1 of 3 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-03-2013, 10:38 AM
  2. Replies: 1
    Last Post: 10-30-2012, 10:29 AM
  3. Replies: 2
    Last Post: 08-16-2012, 10:02 PM
  4. Replies: 4
    Last Post: 08-16-2011, 05:54 PM
  5. Replies: 5
    Last Post: 01-02-2011, 10:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums