Darryl Collins
Darryl.Collins at coles.com.au
Wed Apr 15 23:22:26 CDT 2009
Hi Rocky, What I did was open the table and choose "Form" to create an 'auto-form' based on the table. This produce a 'stacked' type form with a label on the left and the bound text box on the right and the fields listed vertically (it is a very simple table with only 4 fields). Thus I have an auto form like Field1Lablel | Field1BoundTextBox Field2Lablel | Field2BoundTextBox Field3Lablel | Field3BoundTextBox Field4Lablel | Field4BoundTextBox If select any part of the label or text box both would selected. I tried the usual ctrl options when selecting. Oddly the orange border would only show up on one or the other as expected using the ctrl key method, however if I pressed delete then both the label and text box would delete - even if only one was selected, or worse, all four fields would delete. Regardless of what was selected if I changed the size of one of the field, all four fields would replicate the change - ditto for moving. For example I couldn't change them around to look like: Field1Lablel | Field1BoundTextBox Field3Lablel | Field3BoundTextBox Field2Lablel | Field2BoundTextBox Field4Lablel | Field4BoundTextBox Ugly stuff! However, if you select all the fields and then choose 'remove' from the "Arrange" "Control Layout" Group (under form options) it releases them all so they work as before. And yes - it is painfully slow and I have problems with coloured comboboxes not being rendered correctly. Actually, the whole darn product reeks of cheap and nasty. bah bah! regards Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Thursday, 16 April 2009 1:38 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007: Keep bound text box - delete label... In 2003 you select the label, hit delete and it goes away. Just tied it in 2007 and it worked. Am I misunderstanding what you're trying to do? One thing I did notice- you may be right about the grade level 2007 was designed for - it goes...real...slow...ly. I'd say that if I was as proficient with the 2007 IDE as I was with the 2003, it would take about 30% longer to design a form or report in 2007 based on the application's response time alone. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Wednesday, April 15, 2009 8:14 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Access 2007: Keep bound text box - delete label... Hi folks, Building a form based on a table in A2007. Trying to delete the label and keep the bound text box, but I cannot seem to do it. There much be a way to break the link between the text box and the label. Anyone got any pointers? cheers Darryl. This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material.