Dear Access Programmers,
I can't seem to figure this out.
The text boxes that are used to input data via my form are
unbound, I want to restrict the user to only put input that
is one line.
Eg.
Input your surname., you shouldn't be able to press the
enter/return key after since it will take the user to the next
line and the infomation will dissapear in the form box since
its a new line, thus you would have to backup to get the
data back.
How can I limit the data entre to one liners ? is there a simply
way ?
******
Seconly, how come I can't seem to get my toolbox, field list
to show ? I enter the forms and press the design view, but
can't seem to have any other views ? Is there a special key
I can press or what?
2  1711 
There should be buttons on the Design View toolbar that will open up the
Toolbox and Properties sheet.
To prevent the Enter key, in the KeyDown event
If KeyCode = 13 Then KeyCode = 0
--
Wayne Morgan
Microsoft Access MVP
"Earthling" <in******@earthplanet09087.com> wrote in message
news:k9******************@twister01.bloor.is.net.c able.rogers.com... Dear Access Programmers,
I can't seem to figure this out.
The text boxes that are used to input data via my form are
unbound, I want to restrict the user to only put input that
is one line.
Eg.
Input your surname., you shouldn't be able to press the
enter/return key after since it will take the user to the next
line and the infomation will dissapear in the form box since
its a new line, thus you would have to backup to get the
data back.
How can I limit the data entre to one liners ? is there a simply
way ?
******
Seconly, how come I can't seem to get my toolbox, field list
to show ? I enter the forms and press the design view, but
can't seem to have any other views ? Is there a special key
I can press or what?
"Earthling" <in******@earthplanet09087.com> wrote in message news:<k9******************@twister01.bloor.is.net. cable.rogers.com>... Dear Access Programmers,
I can't seem to figure this out.
The text boxes that are used to input data via my form are
unbound, I want to restrict the user to only put input that
is one line.
Eg.
Input your surname., you shouldn't be able to press the
enter/return key after since it will take the user to the next
line and the infomation will dissapear in the form box since
its a new line, thus you would have to backup to get the
data back.
Any reason why your fields are unbound? (You like making work for
yourself?) You could set the field's length in the underlying
table... or I guess you could use the keypress event or something to
check the length of the entry and then set the keyascii value to zero
for every subsequent keypress in that field...
How can I limit the data entre to one liners ? is there a simply
way ?
******
Seconly, how come I can't seem to get my toolbox, field list
to show ? I enter the forms and press the design view, but
can't seem to have any other views ? Is there a special key
I can press or what?
Whoa, wait a minute. If your form in UNBOUND, then of course you
can't get a list of fields. Think about it - the field list is a list
of fields that are in the recordsource for the form. And that
*necessarily* means that the form is bound. Yours isn't, so you have
no fields in your field list. You want fields listed? Bind your
form. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: deko |
last post by:
I need to create different recordsets based on queries that use data from
unbound fields in a form. I've discovered that I can't do this, and instead
need to save the data in question (usually a...
|
by: Dos Lil |
last post by:
I have a unbound field in the subform(for calculating the datediff)
which has the control property ==DateDiff("n",,).
I have another unbound field in the main form which is for displaying
the...
|
by: stuart |
last post by:
I am trying to format a number in an unbound text field using the
following format statement in the field's Exit event:
txt11UnitWeight = Format(txt11UnitWeight, "00000.00")
I want the number...
|
by: Rob NYS |
last post by:
I have a bound form for employee evaluations. This form brings in the
Name, Employee Number, SSN etc. I have 8 unbound text boxes for
evaluation info to be entered into. From my understanding these...
|
by: MLH |
last post by:
Can I somehow set a max length of chars entered
into an unbound textbox control?
| | |
by: Martin |
last post by:
Hi,
I'm having a problem with a datagridview control when trying to read
the value of an unbound checkbox cell.
The code below works fine if I click on any text cell, bound or unbound,
and...
|
by: 7stud |
last post by:
Here is some example code that produces an error:
class Test(object):
def greet():
print "Hello"
t = Test()
t.greet()
TypeError: greet() takes no arguments (1 given)
|
by: TonyJ |
last post by:
Hello!
I just wonder when is it necessary to use unbound datagrid. It's far simpler
to use databound datagrid by using the wizard.
Can you just point on some particularly example when an...
|
by: prakashwadhwani |
last post by:
I have an unbound combo box in the form header. I have used an input
mask "CCCC" 40 times to limit the max number of characters to 40.
When I tab into the combo box & press a character say "K"...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
