Re: Problem with a continuous form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The extra line at the end is there so you can add a new record.

You can remove it by setting the form's AllowAdditions property to Yes. However, if you then load (or filter) the form so that it has no records, there will be nothing to show. The Detail section will go totally blank, and any controls in the Form Header or Form Footer may not work properly either.

More info about the form going blank:
http://allenbrowne.com/casu-20.html

More info about the other controls not working properly:
http://allenbrowne.com/bug-06.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<bruno.barral@xxxxxxxxxx> wrote in message
news:1191514903.784413.278600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I am developping an application in VBA with Access, and I created a
continuous form, to display data coming from a table.

In the form, each line displays data about a project, and each line
has 4 checkboxes at the right, to allow parametrization of the
projects.

My problem is that when my form is displayed, I get logically one line
per project (and that's ok), but I also get an empty line displayed at
the end of the form (all the fields are there, but no data on them).
And moreover, when I click in one of the checkboxes next to this empty
line, another empty line is created. And again, if I click in one of
the checkboxes next to this empty line, a new one is created and so
on.

My question is : how can I manage to make the continuous form display
only the necessary lines for the existing data, but no empty lines,
with this strange behaviour ?

Thank you for any idea or hint.
¨
PS :Locking the checkboxes is not a solution, as the user needs to be
able to check them for parametrization of the corresponding project.

.

Relevant Pages

  • Problem with a continuous form
    ... when I click in one of the checkboxes next to this empty ... how can I manage to make the continuous form display ...
    (microsoft.public.access.formscoding)
  • RE: OWC11 Pivot Table has problem when i use LastChild functions
    ... custom rollup formula or if i set pivot table control always display empty ... *The data/Cube is valid as it work fine in Excel 2003 Pivot Table. ... Microsoft Online Community Support ...
    (microsoft.public.office.developer.web.components)
  • Re: BLANK OE-6 eMail text area in todays and any previous days email
    ... by from my ISP, then the text area of the message is completely empty, so I ... received emails and thir contents are displayed in each one's message window ... I cannot find any "option" that affects the display of message text. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Lost text fields in merge
    ... Then I have it display with the merge data inserted. ... The form contains database fields that fill automatically, ... as checkboxes and text fields that have to be completed manually. ... filled in unless protection is left off. ...
    (microsoft.public.word.docmanagement)
  • Re: ObjectDataSource and DropDownList
    ... deleted the Text value in the Items collection field, it still displays -1 in the drop down and I did check, I am displaying the proper field in the list. ... There's no need to set it to the empty value, because the dropdown will always default to it's top-most item unless specified otherwise. ... How do I display a blank? ...
    (microsoft.public.dotnet.framework.aspnet)