I have a interesting problem. I have noticed that there are users that have been looking for a way to add bullets in Forms and Reports. I have just the opposite. I have a linked table that is bringing in "numbered work instructions" ie 1).........2)...... . Access is automatically putting a [] type bullet infront of each of the different lines, in my report. I have looked in access And tried to find help online but there seems to be no way to turn this off (I don't want the bullets). Anyone know how to turn this feature of in Access Reports?
Bullets in Access
- Thread starter snodrift1
- Start date
Not off hand; however if the spacing is consistent as in this example:
[] text1
[] text2
So that if it is always [] and one space, you could use ...
... to skip over those and only present the remainder of the information in the field. The critical aspect is the spacing since this will run on all fields.
-dK
[] text1
[] text2
So that if it is always [] and one space, you could use ...
Code:
Mid([FieldName], 4)... to skip over those and only present the remainder of the information in the field. The critical aspect is the spacing since this will run on all fields.
-dK
It's not actually brackets that access is putting inthere just the closest thing to being able to putting a box on the post. It is a bullet in the shape of a box/square that Access is autofilling. when the report comes up it loks like this, rememder the [] are actually boxes/squares
1)
[]2)
[]3)
1)
[]2)
[]3)
Ah ... I think I am getting it.
Because it could vary, and if you could be 110% positive that there are no spaces except between the ) and the first character of the beginning text you could use something like
The InStr function returns a position of the first occurence of a space, that number is then used for the Mid function argument.
-dK
Because it could vary, and if you could be 110% positive that there are no spaces except between the ) and the first character of the beginning text you could use something like
Code:
Mid([FieldName],InStr([FieldName], " "))The InStr function returns a position of the first occurence of a space, that number is then used for the Mid function argument.
-dK
Seems that way, Wazz. I wasn't sure if that was real sample or not; hence my 110% guarentee that is always that way.
A modification might work ...
Snodrift, because I haven't seen a complete sampling of your data to make sure all cases are covered so I can't say this is the complete cure. This is the only way I can think of ....
Check out the Mid and InStr functions in Access Help to tweak it to your needs.
-dK
A modification might work ...
Code:
Mid([FieldName],InStr([FieldName], ")"+1))Snodrift, because I haven't seen a complete sampling of your data to make sure all cases are covered so I can't say this is the complete cure. This is the only way I can think of ....
Check out the Mid and InStr functions in Access Help to tweak it to your needs.
-dK
