2 forms to one table

[Cranky]

(Sorry if this seems a repeat of something else - I appear to have
submitted a post with nearly no content)

Hi

Please can someone advise the best way of doing this...

I'm trying to set up a database where two of the text fields are
'recommendation for improvement' and 'recommendations implemented'.
Because the number of characters is restrictive, I wanted
'recommendation2' and 'implemented2' fields as well. However, I didn't
want those visible all the time.

The only ways I could think of to do this were to either have a button
which makes the additional fields appear (... except I wouldn't know
how to do this), or a second form which opens on a button click, where
the information can be input. The problem with the second option is
that it seems to want to create a new dataset.

Does anyone have any suggestions on how to overcome this?

Thanks in advance

S

 

[SusanV]

Restrictive? As in you can' enter enough characters? Make them memo fields
rather than text.

 

[Cranky]

Restrictive? As in you can' enter enough characters? Make them memo fields

rather than text.

Obviously you can't see it, but I'm cringing at how basic that was.

Thanks for the answer, and helping me feel a complete idiot.

Steve

 

[SusanV]

Idiot? No, not at all! Simply something you've learned today! I learn stuff
here every time I visit!

;-D

SusanV

 

[Guest]

Also, the *default* field size of a text field in a table is 50 chars. You
can change this to a max of 255 chars.

 

[Cranky]

Also, the *default* field size of a text field in a table is 50 chars. You
can change this to a max of 255 chars.

Heh, thanks, but no, it needs more - it's for recording
recommendations following complaints about government offices. 255
characters doesn't get _close_.

Steve

 

[John W. Vinson]

Heh, thanks, but no, it needs more - it's for recording
recommendations following complaints about government offices. 255
characters doesn't get _close_.

You can use a Memo field - that gives you 65536 characters (or two billion, if
you fill the field programmatically). That should give you a couple of weeks
worth of complaints about government offices... of course you'll need
SQL/Server and a BIG disk farm to hold all complaints about all offices!!

John W. Vinson [MVP]

 

[Guest]

Sad.........very True, but sad...

(I will not rant, I will not rant, ...)

 

[Cranky]

You can use a Memo field - that gives you 65536 characters (or two billion, if
you fill the field programmatically). That should give you a couple of weeks
worth of complaints about government offices... of course you'll need
SQL/Server and a BIG disk farm to hold all complaints about all offices!!

Well... it's local government, so not _quite_ as bad...