By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Sub Form Control Events

P: n/a
Rob
Hello Access Gurus!
I am developing an application in A2K.I have a subform in which
3 fields exist.The link between the main being an ID field.The other
two fields are both text fields one for the system and the the other
system number.

I want to control the subform events in the sense,some of the system
contain only numeric entries and hence i should prevent users from
entering non numeric characters.When the users enter manually,if they
try entering non numeric characters for certain systems then a message
shld flash and the focus shld remain on the errant entry.
The second is when i take a daily dump of data from a flat file ,the
Systems table contains both numeric and non numeric entries.My
requirement is ,when i scroll the navigation buttons in the main form
,whenever there is a non numeric item in the system number it shld
color it as vbred or some color(to highlight it).Is this possible?

I need help as i am trying to solve this for past two days.

Thanks

Rob
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Shouldn't you be trapping something like the KeyPress event or
something like that and setting the value to zero to make the numeric
keys effectively inoperable inside the given fields?
Nov 12 '05 #2

P: n/a
Rob
Pieter,
Thanks for your reply.I am talking about the records downloaded
already.How would my code identify these records which are in the sub
form?
How can a user see these text entries when he scrolls the navigation
buttons on the main form.

I am enclosing what i wrote in my original post:
I am developing an application in A2K.I have a subform in which
3 fields exist.The link between the main being an ID field.The other
two fields are both text fields one for the system and the the other
system number.

I want to control the subform events in the sense,some of the system
contain only numeric entries and hence i should prevent users from
entering non numeric characters.When the users enter manually,if they
try entering non numeric characters for certain systems then a message
shld flash and the focus shld remain on the errant entry.
The second is when i take a daily dump of data from a flat file ,the
Systems table contains both numeric and non numeric entries.My
requirement is ,when i scroll the navigation buttons in the main form
,whenever there is a non numeric item in the system number it shld
color it as vbred or some color(to highlight it).Is this possible?

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>... Shouldn't you be trapping something like the KeyPress event or
something like that and setting the value to zero to make the numeric
keys effectively inoperable inside the given fields?

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.