I've never used that approach. Always have added a textbox from the toolbox then bound to the field I need, assuming it has to be bound. Either do it that way or you can manually add a label in the same manner, but then it won't be linked/associated with the control. To be more accurate, a textbox is a control, not a field, although when referred to that way by many, it is understood to be a bound control. At least that's how I view it.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Does this happen with every new form with any table?
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.
Notice that your click (or drag) is adding fields to the form's width of almost 16 inches.It is just adding a text box, not the Field box and label.
Try adding farther to the left, maybe 1 inch or so.
Hello June7,
No this only happening with one form in my current database, I'm not sure why it started doing that. I just tried adding a sample form and everything worked fine.
Hello Micron,
I am not purposely doing this. This is what I am getting when I try to 'Add Existing Fields'
Hello,
Here is the db.
You did not post the db file, only the shortcut.
Possibly this is corruption that cannot be explained nor fixed.
Try building form again from scratch.
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.
Hello June7,
Here is the db.
You may have posted the wrong DB. None of the forms display as your image shown in post #1 (and you didn't specify which form had the problem).
Also, your tables are designed in a spreadsheet schema, making your existing forms too wide to view without scrolling across. Proper database design does not have repeating data values that display in your forms horizontally.
Form NCMR Input Form exhibits this behavior.
What I did: new form, copy all controls from old Input form, set RecordSource, add new fields from field list - they are correct size with labels.
As I said, corruption.
Strongly advise you remove all spaces and punctuation from naming convention.
I agree, db is not normalized and may cause you big headaches down the road. Current schema may or may not be optimal for your needs. If you need to do a lot of statistical calcs, could be a nightmare. It is a balancing act between normalization and ease of data entry/output. "Normalize until it hurts, denormalize until works."
Last edited by June7; 03-18-2024 at 06:54 PM.
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.
Hello,
Thank you everyone for the help. I will create a new form. I created this form this way, because I could not figure out how to x-fer the data to a PDF, nor could I figure out to get the report to save and print current record only.
Well if you Google a little, all that will become obvious.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
That statement makes no sense. Exactly how would you use this form to print only current record?
Reports are for printing. Build report and apply filter when opening.
Printing has no bearing on our comments about normalization.
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.