A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can I precisely place text boxes on a form?



 
 
Thread Tools Display Modes
  #1  
Old September 9th, 2005, 11:30 PM
Jerry Crosby
external usenet poster
 
Posts: n/a
Default How can I precisely place text boxes on a form?

With snap to grid turned OFF, why can't I precisely set the top (or left,
right, etc) location of a text box?

I have one that I want placed at 2.3333", but Access insists on changing it
to 2.3326". I've had this problem for some time and it's finally bothered
me enough to submit it.

Maybe a difference of .0007" isn't significant, but when you're trying to
set the tops of text boxes in .25" increments it gets frustrating.

Thanks.

Jerry


  #2  
Old September 10th, 2005, 12:25 AM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

Try changing the GridX and GridY numbers to smaller numbers.

--

Ken Snell
MS ACCESS MVP

"Jerry Crosby" wrote in message
...
With snap to grid turned OFF, why can't I precisely set the top (or left,
right, etc) location of a text box?

I have one that I want placed at 2.3333", but Access insists on changing
it to 2.3326". I've had this problem for some time and it's finally
bothered me enough to submit it.

Maybe a difference of .0007" isn't significant, but when you're trying to
set the tops of text boxes in .25" increments it gets frustrating.

Thanks.

Jerry



  #3  
Old September 10th, 2005, 12:26 AM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

Oops... ignore my reply grid properties.... that doesn't affect the
precision of the control placement..my error.

--

Ken Snell
MS ACCESS MVP

"Jerry Crosby" wrote in message
...
With snap to grid turned OFF, why can't I precisely set the top (or left,
right, etc) location of a text box?

I have one that I want placed at 2.3333", but Access insists on changing
it to 2.3326". I've had this problem for some time and it's finally
bothered me enough to submit it.

Maybe a difference of .0007" isn't significant, but when you're trying to
set the tops of text boxes in .25" increments it gets frustrating.

Thanks.

Jerry



  #4  
Old September 10th, 2005, 12:30 AM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

1 twip = 0.0007"

ACCESS uses twips for alignment/size.

--

Ken Snell
MS ACCESS MVP

"Jerry Crosby" wrote in message
...
With snap to grid turned OFF, why can't I precisely set the top (or left,
right, etc) location of a text box?

I have one that I want placed at 2.3333", but Access insists on changing
it to 2.3326". I've had this problem for some time and it's finally
bothered me enough to submit it.

Maybe a difference of .0007" isn't significant, but when you're trying to
set the tops of text boxes in .25" increments it gets frustrating.

Thanks.

Jerry



  #5  
Old September 10th, 2005, 12:31 AM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

By the way, you can "trick" ACCESS into the number you seek. Enter 2.3336
for the location, and ACCESS will "change' it to 2.3333.

--

Ken Snell
MS ACCESS MVP

"Jerry Crosby" wrote in message
...
With snap to grid turned OFF, why can't I precisely set the top (or left,
right, etc) location of a text box?

I have one that I want placed at 2.3333", but Access insists on changing
it to 2.3326". I've had this problem for some time and it's finally
bothered me enough to submit it.

Maybe a difference of .0007" isn't significant, but when you're trying to
set the tops of text boxes in .25" increments it gets frustrating.

Thanks.

Jerry



  #6  
Old September 10th, 2005, 12:48 PM
Arvin Meyer [MVP]
external usenet poster
 
Posts: n/a
Default


"Jerry Crosby" wrote in message
...
With snap to grid turned OFF, why can't I precisely set the top (or left,
right, etc) location of a text box?

I have one that I want placed at 2.3333", but Access insists on changing

it
to 2.3326". I've had this problem for some time and it's finally bothered
me enough to submit it.

Maybe a difference of .0007" isn't significant, but when you're trying to
set the tops of text boxes in .25" increments it gets frustrating.


Only because computers can't properly use a floating point unless the
denominator is a power of 2 and the datatype allows a float of more than the
number of places in the result. Ken's reason of division by a twip is an
example. While it is close to .0007, the exact division is 1/1440 (a twip is
a 1440th of an inch ... there are 72 points to the inch and 20 twips to the
point). That allows for an error of up to 7 ten thousanths of an inch. (The
human eye cannot resolve a difference anywhere near that)

You can't count on Ken's example *always* holding true because of the
rounding algorithm built into Intel chips.

If your first textbox top is set a power of 2, you can set the rest at
precise .25 intervals because .25 is a denominator of the power of 2 (1/4 or
360 twips)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access


  #7  
Old September 10th, 2005, 06:36 PM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

I like your answer better than mine! g
--

Ken Snell
MS ACCESS MVP


"Arvin Meyer [MVP]" wrote in message
...

"Jerry Crosby" wrote in message
...
With snap to grid turned OFF, why can't I precisely set the top (or left,
right, etc) location of a text box?

I have one that I want placed at 2.3333", but Access insists on changing

it
to 2.3326". I've had this problem for some time and it's finally
bothered
me enough to submit it.

Maybe a difference of .0007" isn't significant, but when you're trying to
set the tops of text boxes in .25" increments it gets frustrating.


Only because computers can't properly use a floating point unless the
denominator is a power of 2 and the datatype allows a float of more than
the
number of places in the result. Ken's reason of division by a twip is an
example. While it is close to .0007, the exact division is 1/1440 (a twip
is
a 1440th of an inch ... there are 72 points to the inch and 20 twips to
the
point). That allows for an error of up to 7 ten thousanths of an inch.
(The
human eye cannot resolve a difference anywhere near that)

You can't count on Ken's example *always* holding true because of the
rounding algorithm built into Intel chips.

If your first textbox top is set a power of 2, you can set the rest at
precise .25 intervals because .25 is a denominator of the power of 2 (1/4
or
360 twips)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access




  #8  
Old September 11th, 2005, 10:40 PM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

Quality over quantity every time! g

--

Ken Snell
MS ACCESS MVP

"Fred Boer" wrote in message
...
Maybe Arvin's answer was better.. but you still outnumber him 4 to 1!
g,d&r

Cheers!
Fred Boer

"Ken Snell [MVP]" wrote in message
...
I like your answer better than mine! g
--

Ken Snell
MS ACCESS MVP


"Arvin Meyer [MVP]" wrote in message
...

"Jerry Crosby" wrote in message
...
With snap to grid turned OFF, why can't I precisely set the top (or

left,
right, etc) location of a text box?

I have one that I want placed at 2.3333", but Access insists on

changing
it
to 2.3326". I've had this problem for some time and it's finally
bothered
me enough to submit it.

Maybe a difference of .0007" isn't significant, but when you're trying

to
set the tops of text boxes in .25" increments it gets frustrating.

Only because computers can't properly use a floating point unless the
denominator is a power of 2 and the datatype allows a float of more
than
the
number of places in the result. Ken's reason of division by a twip is
an
example. While it is close to .0007, the exact division is 1/1440 (a

twip
is
a 1440th of an inch ... there are 72 points to the inch and 20 twips to
the
point). That allows for an error of up to 7 ten thousanths of an inch.
(The
human eye cannot resolve a difference anywhere near that)

You can't count on Ken's example *always* holding true because of the
rounding algorithm built into Intel chips.

If your first textbox top is set a power of 2, you can set the rest at
precise .25 intervals because .25 is a denominator of the power of 2

(1/4
or
360 twips)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access








  #9  
Old September 11th, 2005, 11:07 PM
Fred Boer
external usenet poster
 
Posts: n/a
Default

Maybe Arvin's answer was better.. but you still outnumber him 4 to 1!
g,d&r

Cheers!
Fred Boer

"Ken Snell [MVP]" wrote in message
...
I like your answer better than mine! g
--

Ken Snell
MS ACCESS MVP


"Arvin Meyer [MVP]" wrote in message
...

"Jerry Crosby" wrote in message
...
With snap to grid turned OFF, why can't I precisely set the top (or

left,
right, etc) location of a text box?

I have one that I want placed at 2.3333", but Access insists on

changing
it
to 2.3326". I've had this problem for some time and it's finally
bothered
me enough to submit it.

Maybe a difference of .0007" isn't significant, but when you're trying

to
set the tops of text boxes in .25" increments it gets frustrating.


Only because computers can't properly use a floating point unless the
denominator is a power of 2 and the datatype allows a float of more than
the
number of places in the result. Ken's reason of division by a twip is an
example. While it is close to .0007, the exact division is 1/1440 (a

twip
is
a 1440th of an inch ... there are 72 points to the inch and 20 twips to
the
point). That allows for an error of up to 7 ten thousanths of an inch.
(The
human eye cannot resolve a difference anywhere near that)

You can't count on Ken's example *always* holding true because of the
rounding algorithm built into Intel chips.

If your first textbox top is set a power of 2, you can set the rest at
precise .25 intervals because .25 is a denominator of the power of 2

(1/4
or
360 twips)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access






  #10  
Old September 13th, 2005, 11:23 PM
Jerry Crosby
external usenet poster
 
Posts: n/a
Default

Thanks for all your help, guys. Looks like I may just put it into the
"don't fret the small stuff" category!

Jerry


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking text boxes Volunteer Mom Publisher 7 November 12th, 2008 01:29 AM
Need Help In Printing Current Record in Specific Report RNUSZ@OKDPS Setting Up & Running Reports 1 May 16th, 2005 09:06 PM
Outline Renee Hendershott Page Layout 2 December 25th, 2004 02:49 PM
Dates in a listbox connected to a form... RusCat Using Forms 13 November 25th, 2004 02:31 AM
open a form through a subform in access 2000 Tammy Setting Up & Running Reports 12 October 22nd, 2004 02:43 PM


All times are GMT +1. The time now is 04:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.