How to prevent multiple fields section in a from

  • Thread starter Thread starter Vinod
  • Start date Start date
V

Vinod

Hi All,

I have a from in data sheet view, I don't want the user to select more than
one field in a record i.e., at a time only one field should be in selection.
So I wanted to avoid user user in selection for more than one field at a time
using shift+arrow keys or with cursor on column header or with cursor on
record selector to select more than one record, etc.,

If inselection/infocus fields are more than one macro should display a
message as 'Please select one feild only'.

Please help me out by sharing your ideas and thought on preventing more than
one fields selection.

Advanced Thanks
Vinod
 
Hi All,

I have a from in data sheet view, I don't want the user to select more than
one field in a record i.e., at a time only one field should be in selection.
So I wanted to avoid user user in selection for more than one field at a time
using shift+arrow keys or with cursor on column header or with cursor on
record selector to select more than one record, etc.,

If inselection/infocus fields are more than one macro should display a
message as 'Please select one feild only'.

Please help me out by sharing your ideas and thought on preventing more than
one fields selection.

Advanced Thanks
Vinod
Click to expand...

I'd really suggest using a Continuous Form instead of a datasheet. You can
make it look like a datasheet if you wish, but you get more control - in
particular, I don't believe that a continuous form even supports multiple
field selection.
 
Thanks John for your response,

Now I have hopes by looking at your reply. Please guide me how to make
contineous form look like datasheet view.

Regards
Vinod
 
Create text boxes for all of the fields. Make them all the same height, and
just wide enough that they touch the adjoining text boxes.
Delete the labels, or cut and paste them into the header as column labels.
Align the text boxes vertically, and move them to the top of the section.
Drag the bottom border of the section upward as far as you can. When you
let go it will be aligned with the bottoms of the text boxes.
Hints for moving and arranging text boxes:
To select several text boxes or other controls, hold the Shift key down
while clicking the text boxes, or hold the left mouse button down and draw a
box that emcompasses at least part of each text box you want to select.
This will select anything within that "box".
Use the arrow keys on the keyboard to move the selected controls. Use Shift
+ an arrow key to make the controls bigger or smaller in either direction.
Use Ctrl + Arrow Key to move the controls in small increments. Similarly,
use Ctrl + Shift + Arrow Key to change the size in small increments.
Moving or resizing can be done with one control at a time or several
together.
To align controls, select them and use one of the Align choices on the
Format menu.

The above assumes Access 2003 or earlier. I don't know the details in
Access 2007.
 
Thanks BruceM for your immediate response with detailed description.

I did it and I met the requirement except a blank space between navigation
buttons and last record.

Once again thanks to John and BruceM for your supporting.

Regards
Vinod
 
If it is a continuous form and it has a vertical scroll bar you may not need
the navigation buttons. If there is a form footer or page footer it could
account for the blank space. Also, if there are not enough records to fill
the form top to bottom there will be a space at the bottom.

Vinod said:
Thanks BruceM for your immediate response with detailed description.

I did it and I met the requirement except a blank space between navigation
buttons and last record.

Once again thanks to John and BruceM for your supporting.

Regards
Vinod
Click to expand...
 
I did it and I met the requirement except a blank space between navigation
buttons and last record.
Click to expand...

Turn off the form Footer (View menu), or shrink it down to nothing.
 
Back
Top