2 forms to one table

C

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:)
 
S

SusanV

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

Cranky

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

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
 
S

SusanV

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

;-D

SusanV
 
S

SteveS

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.

:)
 
C

Cranky

SteveS said:
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.
Click to expand...

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

Steve
 
J

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_. ;)
Click to expand...

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]
 
C

Cranky

SteveS said:
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!!
Click to expand...


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