473,326 Members | 2,099 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access Report Grid Alignment...

Hi again,

every I go into Design mode in a report and move something around, it
gets "disaligned" with respect to the underlying grid, either at 8X8
or 9X9 (don't know why at 10X10 you can't see tha grid, either...) and
I have to manually select every control, textbox, whatever and move
each of the sides up and down to "re-align" it correctly to the
grid...

Is it just me missing something or is it a normal behaviour?

Thank you in advance for any help u may provide...

Ciao, Lupo

Oct 18 '07 #1
8 8813
lupo666 wrote:
Hi again,

every I go into Design mode in a report and move something around, it
gets "disaligned" with respect to the underlying grid, either at 8X8
or 9X9 (don't know why at 10X10 you can't see tha grid, either...) and
I have to manually select every control, textbox, whatever and move
each of the sides up and down to "re-align" it correctly to the
grid...

Is it just me missing something or is it a normal behaviour?

Thank you in advance for any help u may provide...

Ciao, Lupo
I don't know what 8x8 or 9x9 is but then I'm looking at a grid in A97.

Is it possible you don't have the SnapToGrid selected under the Format
menu bar?
Oct 18 '07 #2
Dear Salad,

first of all, thank you for your quick reply. I have always had Snap
on, since Access 95. The problem is a little different: If u click on
the report/form property and change the "X Grid" and "Y Grid" from
10-10 to 9-9 or 8-8, you'll see a dotted grid that helps aligning the
different objects...

Let's suppose that u have a label which is 10X3 dots, perfectly on the
dots. If you move the label somewhere else in the form/report, the
label will clearly show one or more sides not aligned with the dots
and u have to select the label, grab the side(s) and pull them away
and then back on the dots to realign them correctly...

Regards, Lupo

On Oct 18, 5:17 pm, Salad <o...@vinegar.comwrote:
lupo666 wrote:
Hi again,
every I go into Design mode in a report and move something around, it
gets "disaligned" with respect to the underlying grid, either at 8X8
or 9X9 (don't know why at 10X10 you can't see tha grid, either...) and
I have to manually select every control, textbox, whatever and move
each of the sides up and down to "re-align" it correctly to the
grid...
Is it just me missing something or is it a normal behaviour?
Thank you in advance for any help u may provide...
Ciao, Lupo

I don't know what 8x8 or 9x9 is but then I'm looking at a grid in A97.

Is it possible you don't have the SnapToGrid selected under the Format
menu bar?- Hide quoted text -

- Show quoted text -

Oct 19 '07 #3
lupo666 wrote:
Dear Salad,

first of all, thank you for your quick reply. I have always had Snap
on, since Access 95. The problem is a little different: If u click on
the report/form property and change the "X Grid" and "Y Grid" from
10-10 to 9-9 or 8-8, you'll see a dotted grid that helps aligning the
different objects...
Gotcha. I alway have grid turned off.
Let's suppose that u have a label which is 10X3 dots, perfectly on the
dots. If you move the label somewhere else in the form/report, the
label will clearly show one or more sides not aligned with the dots
and u have to select the label, grab the side(s) and pull them away
and then back on the dots to realign them correctly...
What version are you using? I don't have a prob with A97.

Maybe it's the graphic adapter. I've had computers before where things
are flaky and will work fine on one computer but not another.
>
Regards, Lupo

On Oct 18, 5:17 pm, Salad <o...@vinegar.comwrote:
>>lupo666 wrote:
>>>Hi again,
>>>every I go into Design mode in a report and move something around, it
gets "disaligned" with respect to the underlying grid, either at 8X8
or 9X9 (don't know why at 10X10 you can't see tha grid, either...) and
I have to manually select every control, textbox, whatever and move
each of the sides up and down to "re-align" it correctly to the
grid...
>>>Is it just me missing something or is it a normal behaviour?
>>>Thank you in advance for any help u may provide...
>>>Ciao, Lupo

I don't know what 8x8 or 9x9 is but then I'm looking at a grid in A97.

Is it possible you don't have the SnapToGrid selected under the Format
menu bar?- Hide quoted text -

- Show quoted text -


Oct 20 '07 #4
lupo666 <lu*****@gmail.comwrote:
>first of all, thank you for your quick reply. I have always had Snap
on, since Access 95. The problem is a little different: If u click on
the report/form property and change the "X Grid" and "Y Grid" from
10-10 to 9-9 or 8-8, you'll see a dotted grid that helps aligning the
different objects...
FWIW I always use a 24x24 grid as that appears to be a newer default of Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Oct 20 '07 #5
Currently, I am using both Access 2000 AND 2007 on two different
machines... I have had this problem ever since I can remember...
graphic cards don't make a difference...

Where do u get 24X24? Anything above 9X9 will not show any dots at
all, just the big squares... plus, both version start with a 10X10
default grid...

Please try this:

new form, design mode, click properties on the gray section of the
form, locate X grid and Y grid, change to 9X9, dots appear...

Now, create a label of 5X20 dots (any size will work). It will be
aligned with the dots covering them where required. Simply drag the
label around and u'll see that at least one size of the label will not
be "on the dots", but rather "close" to them...

Unfortunately, when u have many fields, it will show the disalignment
on screen and on print...

Thanks, Lupo

On Oct 20, 9:26 pm, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:
lupo666 <lupo...@gmail.comwrote:
first of all, thank you for your quick reply. I have always had Snap
on, since Access 95. The problem is a little different: If u click on
the report/form property and change the "X Grid" and "Y Grid" from
10-10 to 9-9 or 8-8, you'll see a dotted grid that helps aligning the
different objects...

FWIW I always use a 24x24 grid as that appears to be a newer default of Access.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Oct 20 '07 #6
Sorry, 24X24 in US, 10X10 in Italy...

Ciao, Lupo

On Oct 21, 1:45 am, lupo666 <lupo...@gmail.comwrote:
Currently, I am using both Access 2000 AND 2007 on two different
machines... I have had this problem ever since I can remember...
graphic cards don't make a difference...

Where do u get 24X24? Anything above 9X9 will not show any dots at
all, just the big squares... plus, both version start with a 10X10
default grid...

Please try this:

new form, design mode, click properties on the gray section of the
form, locate X grid and Y grid, change to 9X9, dots appear...

Now, create a label of 5X20 dots (any size will work). It will be
aligned with the dots covering them where required. Simply drag the
label around and u'll see that at least one size of the label will not
be "on the dots", but rather "close" to them...

Unfortunately, when u have many fields, it will show the disalignment
on screen and on print...

Thanks, Lupo

On Oct 20, 9:26 pm, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:
lupo666 <lupo...@gmail.comwrote:
>first of all, thank you for your quick reply. I have always had Snap
>on, since Access 95. The problem is a little different: If u click on
>the report/form property and change the "X Grid" and "Y Grid" from
>10-10 to 9-9 or 8-8, you'll see a dotted grid that helps aligning the
>different objects...
FWIW I always use a 24x24 grid as that appears to be a newer default of Access.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/- Hide quoted text -

- Show quoted text -

Oct 20 '07 #7
lupo666 <lu*****@gmail.comwrote:
>Sorry, 24X24 in US, 10X10 in Italy...
Aha, that might be the difference. While I'm Canadian and we're mostly metric I'm
old enough that I prefer to run my system in Imperial units.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Oct 21 '07 #8
On Sat, 20 Oct 2007 16:45:52 -0700, lupo666 <lu*****@gmail.comwrote:
>Currently, I am using both Access 2000 AND 2007 on two different
machines... I have had this problem ever since I can remember...
graphic cards don't make a difference...

Where do u get 24X24? Anything above 9X9 will not show any dots at
all, just the big squares... plus, both version start with a 10X10
default grid...

Please try this:

new form, design mode, click properties on the gray section of the
form, locate X grid and Y grid, change to 9X9, dots appear...

Now, create a label of 5X20 dots (any size will work). It will be
aligned with the dots covering them where required. Simply drag the
label around and u'll see that at least one size of the label will not
be "on the dots", but rather "close" to them...

Unfortunately, when u have many fields, it will show the disalignment
on screen and on print...

Thanks, Lupo
In design mode, highlight all the labels in a "column".
Click on Format, then in the drop down menu click on Align then click on Left
or right, your choice.

Highlight all the labels in the next "column" and repeat the Format/Alignment
operations.

In simular fashion you can align rows by top or bottom.

And you can make sizes alike.

Chuck
--
Oct 21 '07 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: CSDunn | last post by:
Hello, I have ‘Snap to Grid' turned off when I am working in the Design View of either a form or report. However, it only seems to be off when I use the mouse. If I try to move controls with...
2
by: kmacon | last post by:
I am looking for a grid control that I can use in an Access report. I have seen Stephan Lebans solution for PrintLines, MS's Dynamic Crosstab query, and several others. However, none of them work...
20
by: Deano | last post by:
Just looking at C Sharp to see if it might be worth my while learning something new. Has anyone here tried a .NET language and tried to replicate a existing Access app? I would be interested to...
2
by: Ironman | last post by:
Dear Access Developers: I have an interesting problem that I hope someone could suggest how to solve: I have the following Report: Col-1 Col-2 -------- ------- 483.3 100
4
by: alexandre.brisebois | last post by:
Hi, I am using access 2003, I would like to know if there is an option to reorganize the tables in a maner that is readable, as we can do in sql sever 2000 or 2005. I have been given a database...
1
by: Stephen Plotnick | last post by:
I have a checkbox in a data grid that does not change it's state until I actually leave the field. I've done this routine several times in other data grids without an issue. I'm using VB.2003. ...
5
by: cj | last post by:
How can I get the 2005 ide to have the dots in the form that the controls are aligned to like in 2003?
9
by: prakashwadhwani | last post by:
Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd...
7
by: scottbouley | last post by:
I am creating an Access report that replicates a preprinted grid form by using bordered text boxes. Each detail row on the preprinted form accomodates two lines. However,some of my records consist...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.