Unbound in MS Access

[mukeshhtrivedi]

Hi I have MS access form which has some text on it in four paragrpahs.
Text in first two prargraphs can be changed if I want to and last two
paragraphs are not modifiable. When I go to Design View, I see that
first two paragraphs shows me as Unbound and text is not displayed. Can
anybody guide me how can I change the text from Unbound section as I
want to change some text so that when I access Form it should show me
with updated text.

Thanks,

[Darryl Kerkeslager]

Text can be either in labels or in textboxes. If you do not want to be able
to edit the text, just display it, use a label. Since you want to modify
the text while in Form View for the first two paragraphs, you have used a
text box. But, the text for that text box does not exist until it is put
there by one of several means:

1. Default text. This is entered from the Default Value property of the
textbox when the Form is loaded. It is available from the Properties of the
textbox, on the Data tab. My guess is that you probably want to modify
this, so that the Form loads with text of your choosing in the textbox, but
the user can then change it.

2. Binding the textbox to a field of a table. This would also imply that
the Form is bound to that table. You could then enter text in the filed,
change it, save it, etc. This may be what you want, since this is what a
database is all about.

3. Setting the text by VBA code.

4. Other methods.
--
Darryl Kerkeslager

<mu************@gmail.comwrote

Hi I have MS access form which has some text on it in four paragrpahs.
Text in first two prargraphs can be changed if I want to and last two
paragraphs are not modifiable. When I go to Design View, I see that
first two paragraphs shows me as Unbound and text is not displayed. Can
anybody guide me how can I change the text from Unbound section as I
want to change some text so that when I access Form it should show me
with updated text.

[Rich P]

It sounds like your paragraphs are contained in separate textboxes. If
this is the case then go to form design view, select one of the
textboxes you want to edit - right click on it and go to the bottom of
the dialog and select properties. This brings up the properties sheet
for that textbox. Select the "All" tab at the top of the property sheet
for that textbox. Look down about 5 or 6 lines and on the left side of
the dialog - one of the properties will say "Default Value". This is
most likely where the text is contained for that textbox. You can
stretch/drag the properties sheet to widen it to read the text or you
can highlight the text and copy it (ctrl+C) and paste it in NotePad to
read the text and edit it. Then copy it from notepad back to the
Default Value line and paste it back in the Default Vaue line with your
edits.

If you don't see any text listed in the Default Value line of the
property sheet then the text is being added programatically either from
a rich text file or from code behind the form. First check the property
sheet for the textbox. If that wasn't it then post back for a further
explanation about dealing with this text programmatically.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[mukeshhtrivedi]

Thanks Darryl and Rich for your prompt response.

Hi Rich I checked in Default Value and there is no any text shows. As
you said that if the text is not showing than it would have added by
programatically. Can you please guide me how can I find the text if it
is programatically.

Mukesh

Rich P wrote:

It sounds like your paragraphs are contained in separate textboxes. If
this is the case then go to form design view, select one of the
textboxes you want to edit - right click on it and go to the bottom of
the dialog and select properties. This brings up the properties sheet
for that textbox. Select the "All" tab at the top of the property sheet
for that textbox. Look down about 5 or 6 lines and on the left side of
the dialog - one of the properties will say "Default Value". This is
most likely where the text is contained for that textbox. You can
stretch/drag the properties sheet to widen it to read the text or you
can highlight the text and copy it (ctrl+C) and paste it in NotePad to
read the text and edit it. Then copy it from notepad back to the
Default Value line and paste it back in the Default Vaue line with your
edits.

If you don't see any text listed in the Default Value line of the
property sheet then the text is being added programatically either from
a rich text file or from code behind the form. First check the property
sheet for the textbox. If that wasn't it then post back for a further
explanation about dealing with this text programmatically.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Rich P]

Hi Mukesh,

First you want to check for code behind the form. To do this go to the
form design view. Then look at the menu bar at the top of the design
view - where you have File, Edit, View.... Now look at the toolbar just
below that menu bar. Go to the right end of that toolbar. If you move
your mouse over the icons - moving to the left from the right end, the
4th icon (or maybe the 5th icon) is a magic wand. When you hold your
mouse over that icon it will say "Build". Now move over 2 more icons.
The square shaped icon will say "Code" when you hold your mouse over it.
Click this icon. This is the "Code" icon. This will bring up the code
module for code behind that form. Here you should seem some code if
there is any programming code behind that form. Copy that code (ctrl-A
to select it and ctrl-C to copy it). Then post back to the news group
here and paste the code that you copied (ctrl-v). I (or someone) will
take a look at the code and advise you further.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[mukeshhtrivedi]

Thanks Rich for all your help.

I see following code;

Private Sub WORD_Click()
On Error GoTo Err_WORD_Click

Dim oApp As Object

Set oApp = CreateObject("Word.Application")
oApp.Visible = True

Exit_WORD_Click:
Exit Sub

Err_WORD_Click:
MsgBox Err.DESCRIPTION
Resume Exit_WORD_Click

End Sub

Thanks, Mukesh
Rich P wrote:

Hi Mukesh,

First you want to check for code behind the form. To do this go to the
form design view. Then look at the menu bar at the top of the design
view - where you have File, Edit, View.... Now look at the toolbar just
below that menu bar. Go to the right end of that toolbar. If you move
your mouse over the icons - moving to the left from the right end, the
4th icon (or maybe the 5th icon) is a magic wand. When you hold your
mouse over that icon it will say "Build". Now move over 2 more icons.
The square shaped icon will say "Code" when you hold your mouse over it.
Click this icon. This is the "Code" icon. This will bring up the code
module for code behind that form. Here you should seem some code if
there is any programming code behind that form. Copy that code (ctrl-A
to select it and ctrl-C to copy it). Then post back to the news group
here and paste the code that you copied (ctrl-v). I (or someone) will
take a look at the code and advise you further.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Rich P]

There should be more code than this. You need to copy all of the code
from the form code module. If that was all the code there was in the
form's code module, then click on the Modules tab in the main database
window. There is probably a standalone code module with more coe.

The code you show here only create a Word Application object - probably
to open a Word doc or RTF as I had originally suggested. So this means
that the text from the uneditable textboxes is coming from an external
file. The trick is to see what external file this is and where it is
located. Once you identify the external file, you only need to edit the
external file and you won't need to touch the code. Note: the external
file may reside on your workstation or it may reside on a network if
more than one user has access to this Database. See if there is anymore
code.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[mukeshhtrivedi]

Hi Rich thank you very much for all your help. You are genius. I was
able to find the text in Code. I will change today as per my
requirement. Again you are awsome.

Mukesh
Rich P wrote:

There should be more code than this. You need to copy all of the code
from the form code module. If that was all the code there was in the
form's code module, then click on the Modules tab in the main database
window. There is probably a standalone code module with more coe.

The code you show here only create a Word Application object - probably
to open a Word doc or RTF as I had originally suggested. So this means
that the text from the uneditable textboxes is coming from an external
file. The trick is to see what external file this is and where it is
located. Once you identify the external file, you only need to edit the
external file and you won't need to touch the code. Note: the external
file may reside on your workstation or it may reside on a network if
more than one user has access to this Database. See if there is anymore
code.

Rich

*** Sent via Developersdex http://www.developersdex.com ***