473,394 Members | 1,887 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,394 software developers and data experts.

Format Detail Section Of A Form

Tom
In the Developers Handbook, Getz provides a way to create a survey report
that displays either a line, Yes/No or multiple choice for each question.
It's done by placing three controls (one for each type of answer) in the
report's detail section and then making the control appropriate for each
question visible in the Format event of the detail section. Can this be
simulated in a form? There's no Detail Format event for a form but can it be
done programatically say in the open event? How does the format event work
in a report? How can a single control be made visible for only one question
and not be visible for all questions?

Thanks!

Tom
Nov 13 '05 #1
1 5727
One of the big differences between a form and a report is that the report
runs only once, in order. So you can change things each time a Detail
Section is formatted, knowing that this will only happen once.
In a continuous view form, in contrast, you are free to move back and
forth from one Detail Section to another, in any order. That's what makes
it so hard to vary the formatting.
If you use a single form view, so you're only showing one question at a
time, it's quite simple to format it as you like in the Form_Current event.
However, if you do that on the continuous form, you'll find you're changing
the format for all the Detail Sections at once!

HTH

"Tom" <No***@email.com> wrote in message
news:6v****************@newsread1.news.atl.earthli nk.net...
In the Developers Handbook, Getz provides a way to create a survey report
that displays either a line, Yes/No or multiple choice for each question.
It's done by placing three controls (one for each type of answer) in the
report's detail section and then making the control appropriate for each
question visible in the Format event of the detail section. Can this be
simulated in a form? There's no Detail Format event for a form but can it be done programatically say in the open event? How does the format event work
in a report? How can a single control be made visible for only one question and not be visible for all questions?

Thanks!

Tom

Nov 13 '05 #2

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

Similar topics

2
by: Dalan | last post by:
This should not be an issue, but it is. I'm sure that someone knows what little piece of code is needed too persuade Access 97 to include a currency format for labels (Avery, mailing type). Have...
2
by: Salad | last post by:
Is there a way to determine which section of a form a control is located in code....besides using the tag property?
1
by: Scott Sabo | last post by:
I have a form & report based on a query which shows details about employees performance reviews (hire date, review date, review submital date, etc). We do 90 day probation reviews as well and I...
1
by: Carolyn | last post by:
I am trying to conditionally format an unbound field in an access form based on the value in another access field. The unbound field is actually the background to the form. I want users to be...
3
by: Melissa | last post by:
What specifically causes the Format event of a report's section to fire? Thanks! Melissa
3
by: kmacon | last post by:
I have a form that contains a command button. The command button's OnClick event builds a report using the CreateReport and CreateReportControl functions and then opens the main report. I set...
4
by: 2D Rick | last post by:
In Access2003 and XP. My forms detail section hides behind the header when I scroll down to see controls off screen. This is similar to freezing a pane in Excel. I'd rather this did not happen...
0
by: Arnold | last post by:
Hi Everyone; In a report, I've essentially recreated a paper sheet by adding various labels--name, date, problem, year, Progress Notes, etc.--and horizontal lines (people have traditionally...
4
by: Eric | last post by:
How to i create a form in tabular format without using wizard. thanks,
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.