Re: [MS_AccessPros] Unwanted grouping

I stand corrected. I was looking at the "Desktop Product Inventory Database" that, when you open it up, clearly is NOT a "desktop" database - it's a web app! In a regular desktop database, you CAN modify the Layout just as Graham mentions below. My original statement stands for a Web App database. Calling that a "desktop" template is a bug.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)




On Feb 10, 2015, at 11:02 PM, 'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi Robin



The instructions I gave you should work for Access 2013.



Select the "ARRANGE" ribbon tab under "FORM DESIGN TOOLS"

Select any of the grouped controls.

Click "Remove Layout" (this is in the "Table" group on the left of the
ribbon, fourth button from the left)



Cheers,
Graham



PS: I'll attempt to include a screenshot, but I don't know if you'll be able
to see it or not:





From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, 11 February 2015 10:04
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Unwanted grouping






Thanks John,

In Design View after I click the 'Arrange' tab the 'AutoFormat' option is
nowhere to be seen. I am using Access 2013 perhaps this is different as
mentioned by Graham.

Cheers,

Robin

At 10/02/2015 08:00 PM, you wrote:



Robin-

You have to select one of the controls in the layout first, then click the
Arrange tab. On the far left is the AutoFormat group. Next is the Control
Layout group, and the button you want is third from the left - Tabular /
Stacked / Remove. Click Remove.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)




On Feb 10, 2015, at 6:19 AM, Robin Chapple robinski@westnet.com.au
<mailto:robinski@westnet.com.au> [MS_Access_Professionals] <
MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals@yahoogroups.com> > wrote:


Thanks Graham
"
In Design view I can get as far as ""On the "Arrange" ribbon "" - and
cannot find a 'remove layout' option.

Cheers,

Robin
At 10/02/2015 11:47 AM, you wrote:



Hi Robin

the Â"featureÂ" is called a Â"layoutÂ". In design view, select the
offending controls, then on the Â"ArrangeÂ" ribbon, near the left, click on
Â"Remove LayoutÂ".

Best wishes,

Graham

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals@yahoogroups.com> [
mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, 10 February 2015 13:33
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Unwanted grouping

I have managed to build a form and I have finished up with s ix of the
labels and fields enclosed in a broken line which is preventing me
change the positions of two fields.

What is this grouping called? How did I happen to win it? How do I remove
it?

Many thanks,

Robin happle







[Non-text portions of this message have been removed]



------------------------------------
Posted by: "Graham Mandeno" <graham@mandeno.com>
------------------------------------


------------------------------------

Yahoo Groups Links







------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/