Extra lines being added to Table

A

aleon

I have a form with several tabs. Two tables are linked to supply the data
for the main form and the subforms. I have several subforms linked to the
main form, and other subforms linked to the other tabs. When entering data to
two of the subforms, it forces new lines on the table then you can't see the
info on the form because the rest of the data in the other columns looks
blank, but it is on a separate line. I checked the master and child links and
all looks ok.
 
U

UpRider

Couple of things to check or do.
In form design mode, for the offending textboxes, look at property sheet
OTHER tab. Make sure ENTER KEY BEHAVIOR is 'default'. After doing this,
hitting enter should skip the cursor to the next tab stop, and *not stay in
the same textbox, with your data disappearing*. The data is still there,
it's on a line below the current line and you can't see it because the
textbox is not tall enough.

Even though you have the 'default' option for the enter key, a user can
still cross you up. CTRL-Enter will force a new line.
You can trap and stop that with:

Private Sub YourTextBox_KeyPress(KeyAscii As Integer)
If KeyAscii = 10 Then KeyAscii = 0 'CR
End Sub

UpRider
 
A

aleon

The Entry Key Behaviour is "default" for these boxes. They force new lines
in the table. I've tried indexing - no duplicates to the id number in the
table, but then it won't allow me to enter data saying indexing prevents
saving.
 
Top