buttons cant be in columns like data.
youd have to manually copy /paste.
paste all columns, then copy/paste all rows.
What if i want to insert data as columns inside a form , To be displayed same like the photo i attached before ?
Perhaps you better attach image of what you want showing fields and data instead of buttons.
If you want to do data entry/edit on a form that does not reflect the actual data structure, then must use UNBOUND form and UNBOUND controls and lots of VBA code.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
This is 4 rows in a table i only selected the name field and put it as continuous form , now i want them to fill up the screen horizontally not vertically as shown in the attached photo , As you can see the rest of window is blank data and it doesn't look good , I need to make the form to be same like the photo attached on my original post.
there is no option in access to do this.
Well, there actually is; but it is like June said in Post #4
I did this for a winery many years ago - used unbound controls and lots of VBA.
VBA had to fill in the data, save the edits, delete old data. Did I say there was a LOT of code???