form datasheet view

[SoxPats83]

is it possible to remove the excel/datasheet appearancs from a form while in datasheet view? what i am asking is can i remove the appearance of any grids and just have it as a white canvas?

 

[boblarson]

Nope, I don't believe so. But you can do that with a continuous form.

 

[boblarson]

Okay, actually you might be able to by setting the gridline color to white.

Check this out about how you can do various things with datasheets.

 

[SoxPats83]

Nope, I don't believe so. But you can do that with a continuous form.

alright, i have changed my form to continuous forms, how is it i make this happen?

 

[boblarson]

Check out my post just before your response.

Also, if you use the continuous form you would need to tighten up the controls to each other, make sure the special effect is set to FLAT, border set to Transparent, and the detail size is brought up tight to the bottom of the controls.

 

[SoxPats83]

Check out my post just before your response.

Also, if you use the continuous form you would need to tighten up the controls to each other, make sure the special effect is set to FLAT, border set to Transparent, and the detail size is brought up tight to the bottom of the controls.

i have taken the continuous forms route. something that is annoying me though is i have a couple of text fields next to each other seperate with a comma "," as a label. the values entered in each of the field varies based on the needs of the end user. wwhat i want is the size/appearance of the text boxes to grow or shrink based upon how much data is inputted. i tried the grow and shrink set to yet in the properties, but i must not fully understand that option's purpose. below is kinda a visual of what i am looking at:

What I Currently Have

hello ,hello

What I Want

hello,hello

 

[boblarson]

Do they need to be editable? If not, you can use ONE text box and display it with a concatenation

=[Field1] & "," & [Field2]

 

[SoxPats83]

unfortunately they are editable. they are to be used by people to input certain findings, so i must be sure to keep them available

 

[SoxPats83]

Do they need to be editable? If not, you can use ONE text box and display it with a concatenation

=[Field1] & "," & [Field2]

what i have going on is the user will type values into a text box on the main form, then they are required to type other values in a different text box. they then click a command button and these values then move to the corresponding fields in the subform.

Private Sub cmdAddtoBody_Click()
  If IsNull(Me.txtNumber) = True Or IsNull(Me.cmbHours) = True Or IsNull(Me.cmbOpen) = True Or _
    IsNull(Me.txtWork) = True Or IsNull(Me.txtnotes) = True Then
      MsgBox "All Fields are Required" 'All fields are required for a line item (record) to be valid.
  Else: DoCmd.Save acForm, "main" 'Add the record to the temporary table.
        DoCmd.GoToRecord acDataForm, "main", acNewRec
    With Me.test 'Requery the subform to show the records that have been saved in the table.
      .Requery
    End With
    
  End If
End Sub

 

[SoxPats83]

the problem i am finding that i am running into is that two of my txt fields do not share a record source with the table field. i want those two txt fields to be combined and then go to the table field