Alireza355, the people on this forum who answer questions are all volunteering their time.You need to understand that in order to
- Not waste their time
- Facilitate their helping you
you really need to "
explain a bit more" in your original post, not after someone has taken the time to answer your question.
Given this new information, the form your subform is based on will need to have a
Query as its
Record Source. If it is currently based on a
Query, you'll need to add a calculated field, by entering something like this in a new, blank field in the
Query Design Grid:
FormatMyField: " " & [MyField]
If the form is currently based on a
Table, you'll need to create a
Query from the
Table, including all the fields, then add the calculated field as shown above. You can easily do this using the
Query Wizard if need be.
If the form was originally based directly on the
Table, go into
Design View for the form and change the
Record Source from the
Table to your newly created
Query.
In either case, you now need to select the textbox and go into
Properties - Data and change the
Control Source from
MyField to
FormatMyField.
The textbox will now display with your spaces in front of the data.
Linq
;0)>.
86
