Blank text box on report to be filled in

[Charles CL]

Dear All,



I have a field which is not related to any field of my database, it is just simple numbering to indicate that the adjacent field's item is the first number (1) and so on. This "number" is not the ID for the particular item. Is it possible to create a text box for user to key in?

Number	Item
1	A
2	B

Attempt to answer:
I tried to put a combo box at there with predefined records as 1, 2, 3, 4....
So that user can key in or click on the drop down list icon to select the number.

However, i think there must be have a better way to do this.

Please advice.

Advance Thanks,
Charles

[June7]

No, cannot 'enter' data into report. What purpose does this number serve?

Possibly textbox RunningSum property is what you need to use. This property is only available on report.

[Charles CL]

Dear June,

Thank you for the solution.
I had successfully make it at properties of the text box,
Control source = 1,
Running sum = over group.
This will auto generate the number with increment for each new records.

So, there is no way to add text in the text box or label?
Because under my item, some remarks needed to be key in by the user but the information is not going to be store in my tables.
I would use grow = yes for the properties of the text box, so that the remarks text box height will auto-adjusted.

e.g.
Item
A <-- from the table
**Item A represent apple. <-- remark to be key in by user, not stored in table.
B
**Item B is not available.
C
-blank <--- empty remarks.
D
**Item D was shipped.

[June7]

The data must be stored in table and report pulls from the table.

Why would you want to have data on report that cannot be reproduced if the report is run again with the same records?

[Charles CL]

Dear June7,

The report will be saved as pdf file for digital signature, and all the report will be printed out as hardcopy and send to the third user.
This remarks (key in by the 2nd user) is useful for the third user only and we are not going to trace back what remark we had make for the third user.
but other field of records will be stored in the table for future trace back.

[June7]

Why is there aversion to saving remarks in table? Open form, enter remarks, run report.

[Charles CL]

Dear June7,

I get the idea already.
Create an unbound text box at form and then link to the text box in the report.

Thanks for the help.

[June7]

But the same remark will show for every record on the report.