Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10346

Re: Data Entry puzzle

Show all headers | View raw

On 11/02/2015 04:20:12, "Stuart McCall" wrote:
> "Patrick Finucane" <patrickfinucanetx@gmail.com> wrote in message
> news:ea4638a6-118e-40b6-9927-f47199bf5ed7@googlegroups.com...
> Hi.  I am working with Access 2013 and so far my impression is that this
> product is a pile of dung. I NEVER had problems with Access like 2013. I
> LOVED 2010.
> 
> Right now, I have a data entry form.  The form's recordsource is a query.
> There is a text box called PON (purchase order number) with some code in
> the AfterUpdate event.  No formatting.  Edits allowed.
> 
> If I enter 1234 in the PON field and press the ENTER key, the value of
> 1234 disappears. If I do it several times, all of a sudden I can't enter
> anything. I have a blank field So I go into debug. I enter: ? Me.PON
> and I'll get
> 1234
> 1234
> 1234....
> up to 25 characters of the field which is its length in the table.
> 
> My AfterUpdate event does not look at the value of PON.  It doesn't have
> restrictions as far as I know.  It just wipes 1234 away after I press the
> Enter key and it stays in the PON field.
> 
> HOWEVER...if I press the TAB key, it keeps 1234 and moves on to the next
> field. I have NEVER seen this in all the years of me programming. I can't
> find any help on Google. I have decompiled, I have closed the app, I have
> compacted the app. Nothing helps.
> 
> Should I get an UZI and bring it in to work and simply blow the crap out
> of the computer? Or do you have any suggestions that will get me over my
> frustration?
> 
> BTW, it does the same thing in a field called Desctiption as well.
> 
> Can I trust A2013?  Is the app worth more than a plug nickel?
> 
> <Reply>
> 
> My reader didn't quote the above for some reason.
> 
> The last Access I worked with was 2003, but (in that version) I remember
> seeing the effect you describe when a textbox is sized to display 1 line
> of data, but has its "Enter key behavior" property set to "New line in
> field". A newline is appended when you hit enter, which pushes up the text
> you just typed, and therefore out of the viewable area. This has the
> effect of "clearing" the control.
> 
> Hope that's it.
> 
> 
> 

Certainly Stewart's diagnosis is correct for Access 2010. 

On the property sheet other tab, make sure the Enter Key Behaviour is set to
Default.

Also check in the File --> Options --> Client settings that the "Move after
enter" is set to "Next Field"

Phil

---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Data Entry puzzle Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-10 15:17 -0800
  Re: Data Entry puzzle "Stuart McCall" <smccall@myunrealbox.com> - 2015-02-11 04:20 +0000
    Re: Data Entry puzzle "Phil" <phil@stantonfamily.co.uk> - 2015-02-11 10:51 +0000
    Re: Data Entry puzzle Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-11 07:12 -0800
      Re: Data Entry puzzle Larry Linson <larry.linson@verizon.net> - 2015-02-11 22:18 -0600
        Re: Data Entry puzzle Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-12 06:33 -0800

csiph-web