Connecting Tech Pros Worldwide Forums | Help | Site Map

Is there a fixed maximum width on a form?

Henro V
Guest
 
Posts: n/a
#1: Nov 12 '05
And if there is one, is there a way to make forms that are wider?
For every day on the form (first field) it needs to be followed by 52(!)
datefields. I've widened the form as far as I can but I lack
space................

Any solutions?

TIA Henro



Peter Russell
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Is there a fixed maximum width on a form?


Henro V previously wrote:
[color=blue]
> And if there is one, is there a way to make forms that are wider?
> For every day on the form (first field) it needs to be followed by 52(!)
> datefields. I've widened the form as far as I can but I lack
> space................
>
> Any solutions?[/color]

Yes, the maximum width is 22 inches. There is no way to make it wider.
Change the design to vertical?
Use Excel instead?

Regards

Peter Russell
Con Giacomini
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Is there a fixed maximum width on a form?


With that large number of fields you might do well to use a Tab Control
form.

Con Giacomini

"Henro V" <maxlesallaud@hotmail.com> wrote in message
news:bpoi6t$ar6$1@news4.tilbu1.nb.home.nl...[color=blue]
> And if there is one, is there a way to make forms that are wider?
> For every day on the form (first field) it needs to be followed by 52(!)
> datefields. I've widened the form as far as I can but I lack
> space................
>
> Any solutions?
>
> TIA Henro
>
>[/color]


TC
Guest
 
Posts: n/a
#4: Nov 12 '05

re: Is there a fixed maximum width on a form?



"Henro V" <maxlesallaud@hotmail.com> wrote in message
news:bpoi6t$ar6$1@news4.tilbu1.nb.home.nl...
[color=blue]
> And if there is one, is there a way to make forms that are wider?[/color]
(snip)


If there is a fixed maximum, but there is also a way to exceed that maximum,
then it would not be a maximum, would it!

This is a serious comment. You are wasting your time by asking how to bypass
a fixed maximum.

"Access has a limit of 255 fields per table. How can I get more?"
answer: you can't!

& so on.

HTH,
TC



Henro V
Guest
 
Posts: n/a
#5: Nov 12 '05

re: Is there a fixed maximum width on a form?


Default are text fields limited on 50 characters (fixed with) but you can
crank it up to 255. That was my question!

Henro

"TC" <a@b.c.d> wrote in message news:1069560933.533108@teuthos...[color=blue]
>
> "Henro V" <maxlesallaud@hotmail.com> wrote in message
> news:bpoi6t$ar6$1@news4.tilbu1.nb.home.nl...
>[color=green]
> > And if there is one, is there a way to make forms that are wider?[/color]
> (snip)
>
>
> If there is a fixed maximum, but there is also a way to exceed that[/color]
maximum,[color=blue]
> then it would not be a maximum, would it!
>
> This is a serious comment. You are wasting your time by asking how to[/color]
bypass[color=blue]
> a fixed maximum.
>
> "Access has a limit of 255 fields per table. How can I get more?"
> answer: you can't!
>
> & so on.
>
> HTH,
> TC
>
>
>[/color]


Larry Linson
Guest
 
Posts: n/a
#6: Nov 12 '05

re: Is there a fixed maximum width on a form?


"Henro V" wrote
[color=blue]
> Default are text fields limited on 50
> characters (fixed with) but you can
> crank it up to 255. That was my question![/color]

No, not exactly. Text fields are defaulted to a lenght 50, and since they
are variable-length, that is the _specified_ "limit" but that is not a
"maximum".

The _maximum_ for text fields is 255, and the only workaround is to use a
different field type, for example, Memo fields which can contain 65K (and
are actually physically stored outside the table in which they are defined).

Larry Linson
Microsoft Access MVP


TC
Guest
 
Posts: n/a
#7: Nov 12 '05

re: Is there a fixed maximum width on a form?



"Henro V" <maxlesallaud@hotmail.com> wrote in message
news:bpq51p$u5k$1@news4.tilbu1.nb.home.nl...
[color=blue]
> Default are text fields limited on 50 characters (fixed with) but you can
> crank it up to 255. That was my question![/color]

Silly me! I thought your question was:

"Is there a fixed maximum width on a form?
And if there is one, is there a way to make forms that are wider?"

TC

[color=blue]
> Henro
>
> "TC" <a@b.c.d> wrote in message news:1069560933.533108@teuthos...[color=green]
> >
> > "Henro V" <maxlesallaud@hotmail.com> wrote in message
> > news:bpoi6t$ar6$1@news4.tilbu1.nb.home.nl...
> >[color=darkred]
> > > And if there is one, is there a way to make forms that are wider?[/color]
> > (snip)
> >
> >
> > If there is a fixed maximum, but there is also a way to exceed that[/color]
> maximum,[color=green]
> > then it would not be a maximum, would it!
> >
> > This is a serious comment. You are wasting your time by asking how to[/color]
> bypass[color=green]
> > a fixed maximum.
> >
> > "Access has a limit of 255 fields per table. How can I get more?"
> > answer: you can't!
> >
> > & so on.
> >
> > HTH,
> > TC
> >
> >
> >[/color]
>
>[/color]


Closed Thread


Similar Microsoft Access / VBA bytes